Ansicht
Dokumentation
SQL4001 - Temporary result created. ( OS/400 )
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up BAL Application Log DocumentationThis documentation is copyright by IBM.
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 )