Ansicht
Dokumentation

SQL400E - Temporary distributed result file &1 was created while processing distributed subquery. ( OS/400 )

SQL400E - Temporary distributed result file &1 was created while processing distributed subquery. ( OS/400 )

CPI1466 during Backup   CPI1466 during Backup  
This documentation is copyright by IBM.
SAP E-Book


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 )