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?
What is lock escalation in db2?
What is the advantage in De-normalizing tables in DB2?
How many databases can be created inside an instance in db2 ?
How do you eliminate duplicate values in db2?
What are packages in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is ibm db2 client?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is runstats db2?
What do you mean by cursor?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a plan and package in db2?
What are concurrency issues?
How to test SQL -911 error while developing COB-DB2 program