can any one give the list of some important sql abend codes
which r frequently asked in interviews?
Answer Posted / s.v.venkata sivaprasad
0 successful execution and row found
100 successful but row nt found or end of file
-818 time stamp token mismatch
-811 multiple rows retrieving by using sql statement in
application program
-911/-913 time out due to dead lock
-904 plan not found corresponding load module
-305 null valule
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are db2 objects?
Explain in brief how does db2 determine what lock-size to use?
What is dbrm in db2 database?
List out the data types available.
What is db2 catalog database?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain the contents that are a part of dclgen.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What's The Percentage Free Space ?
Mention the location where the output received from explain statement is stored.
Explain in detail about buffer manager and its functionalities?
Why select is not preferred in embedded sql programs?
How will you return the number of records in table?
Explain about open switch business continuity software?
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