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
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the role of data manager in the db2 database?
What is blu acceleration in db2?
What is db2? Explain.
What is reorg and runstats in db2?
Why cursor is used in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to create db2 table in mainframe?
What is reorg?
Explain the function done by data manager?
What is data manager?
What is dclgen (declaration generator)?
What do you mean by storage group (stogroup)?
What is declare cursor?
What parameters are used to control the free space in DB2?