can anyone tell me how to solve the following error :
SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS
INVALID BECAUSE INDEX IN INDEX SPACE "..." CONSTRAINS
COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE
VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'0000A0490C
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
I see that you have masked the index name in the message.
Run the following query,
SELECT * FROM SYSIBM.SYSKEYS
WHERE IXNAME = 'XXXX'
where xxxx is the index name which you got from the error message.
You could get the column names which are defined as unique/Primary for that table.
So it means that Not more than one row can have the same value.
It has to be unique. Hope this helps