Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to resolve -803 DB2 error: UPDATED VALUE IS INVALID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
satish_mf

New User


Joined: 19 Mar 2007
Posts: 1
Location: chennai

PostPosted: Tue Mar 20, 2007 2:21 pm    Post subject: How to resolve -803 DB2 error: UPDATED VALUE IS INVALID
Reply with quote

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
View user's profile Send private message

saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Tue Mar 20, 2007 2:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Wed Mar 21, 2007 1:22 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sachin_star3
Warnings : 1

New User


Joined: 30 Sep 2006
Posts: 78
Location: pune

PostPosted: Sun Apr 08, 2007 3:18 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 0 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us