SQL code -803



Get solution for your ABEND Codes & System Error Messages, SQL Codes, File Status etc...

SQL code -803

Postby jvinoth » Wed Dec 07, 2011 3:26 pm

I am getting the SQL code -803 when trying to submit the job so please help me to slove this problem.
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SQL code -803

 

Re: SQL code -803

Postby Akatsukami » Wed Dec 07, 2011 3:49 pm

jvinoth wrote:I am getting the SQL code -803 when trying to submit the job so please help me to slove this problem.

What problem?

You've shown us no SQL, no JCL, no sysouts -- nothing, in fact, that would lead us to not to believe that you aren't seeing the reflection of a Post-it note on your monitor.

You should know better than to write so worthless a post. If you didn't, you do now. If you can't learn, you won't last long in this business.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: SQL code -803

Postby jvinoth » Wed Dec 07, 2011 4:07 pm

SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID
BECAUSE INDEX IN INDEX SPACE NPSCXWD1 CONSTRAINS COLUMNS OF THE TABLE
SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF
EXISTING ROW IS X'0030010711.

While inserting into the table i'm getting this error k
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SQL code -803

Postby BillyBoyo » Wed Dec 07, 2011 4:11 pm

So, even with this very limited amount of information, don't you think you are trying to insert/update that would give a duplicate value, when this is not allowed according to an index that exists for the table?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SQL code -803

Postby jvinoth » Wed Apr 18, 2012 12:58 pm

[cd]
hi

[/cd]
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SQL code -803

Postby dick scherrer » Wed Apr 18, 2012 11:47 pm

Hello,

Is/was there a reason for the last post :?

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to ABENDS & SQL Codes

 


  • Related topics
    Replies
    Views
    Last post