View previous topic :: View next topic
|
Author |
Message |
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?? |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
vini_srcna
Active User
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 |
|
Back to top |
|
|
sachin_star3 Warnings : 1 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 |
|
Back to top |
|
|
|