Ansicht
Dokumentation

SQL4015 - From-column &1.&2, to-column &3.&4, join operator &5, join predicate &6. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by IBM.


Message : SQL4015
From-column &1.&2, to-column &3.&4, join operator &5, join predicate &6.

Message Long Text :

Cause . . . . . : Identifies which join predicate was implemented at the current join position. The replacement text parameters are:
-- &1: The join 'from table' number. The table number refers to the relative position of this table in the query.
-- &2: The join 'from column' name. The column within the join from table which comprises the left half of the join column pair. If the column name is *MAP, the column is an expression (derived field).
-- &3: The join 'to table' number. The table number refers to the relative position of this table in the query.
-- &4. The join 'to column' name. The column within the join to column which comprises the right half of the join column pair. If the column name is *MAP, the column is an expression (derived field).
-- &5. The join operator. Possible values are EQ (equal), NE (not equal), GT (greater than), LT (less than), GE (greater than or equal), LE (less than or equal), and CP (cross join or cartesian product).
-- &6. The join predicate number. Identifies the join predicate within this set of join pairs.
Recovery . . . : 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 joins.

Message File : QSQLMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3266 Date: 20240425 Time: 231624     sap01-206 ( 4 ms )