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 Usergroups Profile Log in to check your private messages Log in
 

 

DB2- Deleting a row in a table gives -803

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

New User


Joined: 22 Aug 2006
Posts: 16

PostPosted: Tue Oct 10, 2006 7:34 pm    Post subject: DB2- Deleting a row in a table gives -803
Reply with quote

Hi guys,

when deleting a particular row in a table iam getting an -803 error. As I was able to view only the front end screen I was not able to provide the exact query which is running in the back end.

Can you please let me know when this situation will occur.

Thanks and regards
Back to top
View user's profile Send private message

MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Tue Oct 10, 2006 7:48 pm    Post subject: Re: DB2- Deleting a row in a table gives -803
Reply with quote

Probably, when a row is deleted, deleted row is inserted in a history table and this not working properly or error not handled properly. You would need to get to know what application is doing and what SQL's are executed for this operation.

And here is what -803 is:

Code:

-803 AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX       
       SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO       
       ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING   
       ROW IS Xrid                                                           
                                                                             
Explanation:  The table that is the object of the INSERT or UPDATE           
operation is constrained (by UNIQUE INDEX in the INDEX SPACE                 
indexspace-name to have unique values in certain columns. Completion of       
the requested INSERT or UPDATE would result in duplicate values occurring     
in row rid.                                                                   
                                                                             
If a view is the object of the INSERT or UPDATE statement, the table that     
defines the view is constrained. The update might also be caused by a         
DELETE operation of a parent row that cascades to a dependent row with a     
delete rule of SET NULL.                                                     
                                                                             
System Action:  The INSERT, UPDATE, or DELETE statement cannot be             
executed. The object table is unchanged.                                     
                                                                             
Programmer Response:  Examine the definitions for UNIQUE INDEX in the         
INDEX SPACE indexspace-name to determine the uniqueness constraint           
Back to top
View user's profile Send private message
raviprasath_kp
Warnings : 1

New User


Joined: 20 Feb 2005
Posts: 65
Location: chennai

PostPosted: Fri Oct 13, 2006 9:48 pm    Post subject:
Reply with quote

Mainly this error occours because
IN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'rid'
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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