Ansicht
Dokumentation

SQL0338 - JOIN predicate or MERGE ON clause not valid. ( OS/400 )

Addresses (Business Address Services)   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : SQL0338
JOIN predicate or MERGE ON clause not valid.

Message Long Text :

Cause . . . . . : The JOIN predicate, or ON clause of a MERGE statement, is not valid because a column is specified that exists in a table that is outside the scope of the join predicate or ON clause. The scope is generally determined from left to right but is also based on the position of the join-condition. If parentheses are used, columns inside the parentheses cannot come from a table outside the parentheses. If an implicit join (using a comma) is specified prior to a joined table with an ON clause, columns in the ON clause cannot come from a table before the comma.
Recovery . . . : Do one of the following and try the request again:
-- Make certain that the column names, table names, and any qualifiers are specified correctly.
-- Specify parentheses around joined tables to specify a join order other than left to right. Ensure columns exist in tables that are in the same scope.
-- For an ON clause in a MERGE statement, ensure referenced columns are within the scope of the ON clause.
-- Specify a CROSS JOIN instead of an implicit join.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3234 Date: 20240424 Time: 085328     sap01-206 ( 2 ms )