How to resolve -803 sql code in DB2?
Answers were Sorted based on User's Feedback
Answer / lakshmi
This error is thrown when you try to insert a row with
existing primary key i.e.Duplicate. If you want to insert
the row either you should delete the already existing row
and insert the new row or update the same row with the new
values for other fields
Is This Answer Correct ? | 22 Yes | 8 No |
Answer / venkata sastry
The SQL - 803 error occurs on the violation of a UNIQUE
constraint. Update the record if it already exists rather
inserting new one.
Is This Answer Correct ? | 15 Yes | 6 No |
Answer / lu
Before to insert, it's better to select(retrieve),test
sqlcode when 100 insert when 00 update whenever send
message and abend...You don't have an heache....
Is This Answer Correct ? | 5 Yes | 3 No |
What is dbrm? When it will be created?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Can you define an Index if the table size less than 10 PAGES?
What is load utility in db2?
What is a DB2 access path?
What are the bind parameters ibm db2?
What is plan in cobol db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is performance tuning db2?
What os does db2 run on?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
wht r the requirements for writing a cobol-db2 pgm ?