DB2 SQL-Error: -530
SQLState: 23503
Short Description: THE INSERT OR UPDATE VALUE OF FOREIGN KEY IS INVALID
An UPDATE or INSERT operation attempted to place a value in a foreign key of the object table; however, this value was not equal to some value of the parent key of the parent table. When a row is inserted into a dependent table, the insert value of a foreign key must be equal to the value of the parent key of some row of the parent table in the associated relationship. When the value of the foreign key is updated, the update value of a foreign key must be equal to the value of the parent key of some row of the parent table of the associated relationship. System action: The UPDATE or INSERT statement cannot be executed. The object table is unchanged. Programmer response: Examine the insert or update value of the foreign key first, and then compare it with each of the parent key values of the parent table to determine the cause of the problem.