Ansicht
Dokumentation
SQL400E - Temporary distributed result file &1 was created while processing distributed subquery. ( OS/400 )
CPI1466 during Backup CPI1466 during BackupThis documentation is copyright by IBM.
Message : SQL400E
Temporary distributed result file &1 was created while processing distributed subquery.
Message Long Text :
Cause . . . . . : A temporary distributed result file was created to contain the intermediate results of the query. The query contains a subquery which requires an intermediate result.
Recovery . . . :
Generally, if the fields correlated between the query and subquery do not match the partition keys of the respective files, the query must be processed in multiple steps and a temporary distributed file will be built to contain the intermediate results.
For more information on the processing of distributed files, refer to the DB2 Multisystem topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/.
Message File : QSQLMSG
Library Message File : QSYS2924
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by IBM.
Length: 3273 Date: 20240329 Time: 144823 sap01-206 ( 2 ms )