Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
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
 
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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us