Ansicht
Dokumentation

SQL4007 - Query implementation for join position &1 table &2. ( OS/400 )

SQL4007 - Query implementation for join position &1 table &2. ( OS/400 )

ROGBILLS - Synchronize billing plans   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL4007
Query implementation for join position &1 table &2.

Message Long Text :

Cause . . . . . : The join position identifies the order in which the tables are joined. A join position of 1 indicates this table is the first, or left-most, table in the join order. The table number refers to the relative position of this table in the query.
Recovery . . . : Join order can be influenced by adding an ORDER BY clause to the query. Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center, http://www.ibm.com/systems/i/infocenter/, for more information on join optimization and tips to influence join order.

Message File : QSQLMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3233 Date: 20240329 Time: 081106     sap01-206 ( 3 ms )