What is SQLCODE=-803 Error?

satish_mf · New User Joined: 19 Mar 2007 Posts: 1 Location: chennai

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

Also let me know how to view the index space??

saiprasadh · Active User Joined: 20 Sep 2006 Posts: 154 Location: US

Hi,

You are trying to insert a row with primary key value which is already present in the table, That's why you are getting -803.

Sai

vini_srcna · Posted: Wed Mar 21, 2007 1:22 pm

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

sachin_star3 · New User Joined: 30 Sep 2006 Posts: 78 Location: pune

THIS IS WHEN YOU VIOLATE THE PRIME KEY

YOU HAVE CREATE THE TABLE AND ONE COLOUMN WITH PRIMARY KEY

AN D WHEH WE INSERT THE SAME DATA IN THE PRIMARY KEY COLOUMN
SO YOU WIIL GET THE -803
I.E SAME FILE STATUS 22 IN COBOL

FROM-SACHIN BORASE
PUNE