what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 13220 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 db2? Explain.
What is a DB2 catalog?
what is different three logs in DB2?
What is the maximum number of columns in a db2 table?
is it possible to get -811 error when you use cursors. why?
How to define the data items to receive the fetch items for the SQL?
What is check constraint. Explain with example.
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is a system catalog table in db2?
What is image copy in db2?
COBOL 
