what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 12935 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What are the disadvantages of PAGE level lock?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
How can you count the number of rows from a table tab?
what is difference between random and sequence file access
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. TIA
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
How to find primary key of a table in db2?
Can you use max on a char column?
What are the various locks available?
How do you check for a null value in a db2 column?
What is meant by a unit of recovery?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
COBOL 
