Sql Code -803

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

I am trying to execute below query through cobol program

EXEC SQL
INSERT INTO MRTW_SKU_PKGNG_OVRRID
VALUES (6,'E',8,9)
END-EXEC.

Its working fine in QMF but when I run cobol db2 program I get sql code -803 . My table is empty and this is the only one record I am trying to insert. The error is as :-

2300-INSERT-TABLE-DATA
** ABEND ** ** = SQLERROR
** PROGRAM ** = MRKUT003
** SQLCODE ** = 803-
** ROWS PROCESSED ** = 0
** SQLERRM ** = MRIWRSKU 0000000202
** SQLERRMC ** = MRIWRSKU 0000000202 .

Please suggest what can be the resolution

Pandora-Box · Posted: Thu Jun 07, 2012 10:12 am

Is your program trying to perform an insert multiple times ?

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Yes I have a input file with several records and I am doing Insert 2300-INSERT-TABLE-DATA Until EOF.

Pandora-Box · Posted: Thu Jun 07, 2012 10:34 am

I mean to say your program is trying to do an insert for same key values

chances that your input file could contain duplicates is very high

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Nops

I have my table empty and I am trying insert only one record so there is no chance of duplicate values. Not sure whats happening

Pandora-Box · Posted: Thu Jun 07, 2012 10:38 am

Are you trying to do the call to insert para more than once??

Also how many records do your input file contain?
how many times you call the insert para/section?

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

I had called insert para only once and there is only one record in my input file.

Perform INSERT Until EOF

I think after one read it will set EOF to true and it will go into insert only once.

Pandora-Box · Posted: Thu Jun 07, 2012 10:52 am

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

okay

yes I got it

Thank you so much for help

Thanks a lot

Anuj Dhawan · Posted: Thu Jun 07, 2012 11:03 am

Telling us the PARA-name from your program won't help us to help you. Did you check in the manuals for SQLCODE= -803. As Pandora-Box indicates about duplicate records/rows, check if the table that is the object of the insert or update operation is constrained by UNIQUE INDEX in the INDEX SPACE to have unique values in certain columns.