what's the error code for Unique Index Violation?
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
-803 is th error code for the Unique Index Violation
| Is This Answer Correct ? | 5 Yes | 2 No |
B37 abend during spufi?
How Plan is created while executing the query using SPUFI?
What is the result of open cursor statement?
db2 restart logic ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is ALTER ?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is commit in db2?
How do you do the EXPLAIN of a dynamic SQL statement?
What is the meaning concurrency in the db2 database?