what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
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 parameters are used to control the free space in DB2?
What is index in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What does an outer join do?
what is difference between random and sequence file access
What are simple, segmented and partitioned table spaces ?
What is release/acquire in bind?
what is db2 restart?
What's the maximum number of volumes that can be added to a STOGROUP?
Plan has the optimized access path in it. But is that optimized access path is attained or known