what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 13118 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 is static sql? what is dynamic sql? Give me details
What is an inner join, and an outer join ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
Which components manage deadlocks in db2?
List out the three types of page locks that can be held.
How do you find the maximum value in a column in db2?
What is the clustering index in the db2 database?
What does the REORG Utility do?
What Utility is used to migrate DB2 from one release to the next?
select 100 records from million records ?
COBOL 
