what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
Answer Posted / sachin
-100 when the rows found.
-805 plan not found
-305 null indicator not declared
-104 invalid keyword
-199 illegal use of keyword
-206 table not foung
-310 for decimal column using non decimal
-407 try to insert the null value in the not null column
-501 try to close the curosr which are already open
-811 multirow select
-504 cursor not decalred
-818 time stamp mismatch
-180 date error
-181 date and time are invalid
-414 in the union the column are not same
-911
-913 both are for the deadlock
-904 for the resource not avable
-922 authorization failure
-924 coneection is not availbke
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is database manager in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
Why do we bind in db2?
What is dclgen in db2?
How do I delete a table in db2?
What is view db2?
How can you count the number of rows from a table tab?
What is package in cobol db2?
How do you eliminate duplicate values in db2?
What is explain plan in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Why do we need reorg in db2?
What is the syntax for FETCH in DB2 ?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is iseries database?