Friday, July 13, 2012

SQL0803N: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "STMT_REVISION".

Run the following query to trace the error:


SELECT INDNAME, INDSCHEMA
FROM SYSCAT.INDEXES
WHERE IID = <Index Id>
AND TABSCHEMA = '<Schema Name>'
AND TABNAME = '<Table Name>';


For Example:

SELECT INDNAME, INDSCHEMA
FROM SYSCAT.INDEXES
WHERE IID = 1
AND TABSCHEMA = 'FIG_ADS'
AND TABNAME = 'STMT_REVISION';

No comments :