Multiple choice technology databases

Which SQLCODE is used to check for duplicate index on a column

  1. -803

  2. -811

  3. -805

  4. -855

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQLCODE -803 in DB2 indicates a duplicate key violation, which occurs when an INSERT or UPDATE tries to create a duplicate value in a column with a unique constraint or index. This error specifically signals that the inserted data violates uniqueness requirements.