Ansicht
Dokumentation

SQL0212 - Duplicate table designator &1 not valid. ( OS/400 )

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


Message : SQL0212
Duplicate table designator &1 not valid.

Message Long Text :

Cause . . . . . : One of the following has occurred:
-- More than one table in a FROM clause of a subselect has a table designator with the name &1. If a correlation name is specified, the correlation name is the table designator. If one is not specified, the table name or view name is the table designator. If SQL naming is specified, the table name consists of the implicit or explicit schema name followed by the actual table name. If system naming is specified, the table name itself is used without a qualifier as the table designator. The table designator must be unique on each level of a subselect.
-- Names specified in the REFERENCING clause of a CREATE TRIGGER statement are not unique. The names specified for the NEW and OLD correlation name and the NEW_TABLE and OLD_TABLE names must be unique and must not be the same as the table on which the trigger is being defined.
Recovery . . . : Make certain there is a unique table designator for every table in a FROM clause for the same level of a subselect. Since schema-name/table-name cannot be used to qualify a column, the table name must be unique or a correlation name must be specified. Specify unique names in the REFERENCING clause of the CREATE TRIGGER statement. Correct any errors and try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3226 Date: 20240418 Time: 023814     sap01-206 ( 3 ms )