what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 14435 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 Runstats? Whem will u choose to runatats?
wht is d/f between union and joins ?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is the purpose of the DSNC transaction ?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What are the isolation levels possible ?
what is SPUFI ?
Where are plans stored?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is the STOSPACE Utility used for?
COBOL 
