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 is syscat in db2?
When can an insert of a new primary key value threaten referential integrity?
How to check sequence on a table in db2?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what is + sign and -ve sign for sql code ?
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 is referential integrity?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is meant by union and union all?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
when does the SQL statement gets executed when you use cursor in the application programming ?