Interested to Buy Any Domain ? << Click Here >> for more details...
what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 14150 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 |
wht r the requirements for writing a cobol-db2 pgm ?
What is subquery ?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is Call attach facility? How does it work?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What else is there in the PLAN apart from the access path?
How do I delete a table in database?
Can you define an Index if the table size less than 10 PAGES?
WHAT IS MEANT BY COMMIT COMMAND?
What is load utility in db2?
Mention the various locks that are available in db2.
COBOL 
