Ansicht
Dokumentation

SQL0573 - Table &1 in &2 does not have a matching parent key. ( OS/400 )

General Data in Customer Master   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : SQL0573
Table &1 in &2 does not have a matching parent key.

Message Long Text :

Cause . . . . . : A referencing column list was specified in the FOREIGN KEY clause for constraint &3 in &4. The parent table &1 in &2 does not have a matching PRIMARY or UNIQUE key. If the file is partitioned, the access path of the parent file must be non-partitioned. The constraint cannot be added.
Recovery . . . : Do one of the following and try the request again:
-- Specify a table in the FOREIGN KEY clause that has a PRIMARY or UNIQUE key that matches the referencing column list.
-- Change the referencing column list to match the definition of the PRIMARY or UNIQUE key defined on the parent table.
-- If the parent file is partitioned, add a non-partitioned access path.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3239 Date: 20240418 Time: 021947     sap01-206 ( 4 ms )