PL/I · DB2 SQLCODE
What does SQLCODE -803: Duplicate Key Value in Insert or Update mean in PL/I?
An INSERT or UPDATE issued from the PL/I program would create a row whose value duplicates an existing row's value in a column enforced unique by a primary key, unique constraint, or unique index.
An INSERT or UPDATE issued from the PL/I program would create a row whose value duplicates an existing row's value in a column enforced unique by a primary key, unique constraint, or unique index.
Check for the duplicate before inserting, or catch -803 in the SQLCA and treat it as an expected 'already exists' case, and verify the host variables driving the key columns are actually distinct across the rows being loaded.