Ansicht
Dokumentation

SQL0121 - Duplicate name &1 not allowed. ( OS/400 )

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by IBM.


Message : SQL0121
Duplicate name &1 not allowed.

Message Long Text :

Cause . . . . . : Name &1 is specified more than once in the column list of an INSERT statement, in the SET clause of an UPDATE statement, in an INSERT or UPDATE within a MERGE statement, or in the list of target host variables in the SET or VALUES INTO statement. For a data change INSERT statement, each column name in the INCLUDE clause must be unique and must not duplicate any column name in the INSERT table. If the specified names are not the same, then one of the following has occurred:
-- If the object is a view, two columns in the view may identify the same column in the base table.
-- The names may correspond to the same system column name.
Recovery . . . : Do one of the following and try the request again:
-- Remove the duplicate column.
-- Specify a column list on the statement to remove the duplicate column.

Message File : QSQLMSG
Library Message File : QSYS2924


General Material Data   General Material Data  
This documentation is copyright by IBM.

Length: 3220 Date: 20240426 Time: 193421     sap01-206 ( 2 ms )