Ansicht
Dokumentation

SQL4001 - Temporary result created. ( OS/400 )

SQL4001 - Temporary result created. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   BAL Application Log Documentation  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL4001
Temporary result created.

Message Long Text :

Cause . . . . . : Conditions exist in the query which cause a temporary result to be created. One of the following reasons may be the cause for the temporary result:
-- The table is a join logical file and its join type (JDFTVAL) does not match the join-type specified in the query.
-- The format specified for the logical file refers to more than one physical table.
-- The table is a complex SQL view requiring a temporary table to contain the results of the SQL view.
-- The query contains grouping columns (GROUP BY) from more than one table, or contains grouping columns from a secondary table of a join query that cannot be reordered.
Recovery . . . : Performance may be improved if the query can be changed to avoid temporary results.

Message File : QSQLMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3215 Date: 20240328 Time: 095803     sap01-206 ( 3 ms )