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
- 14188 Views
- Xansa, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What language is db2 written in?
What is scrollable cursor in db2?
How can deadlocks be resolved?
What is null indicator in db2?
What are the bind parameters ibm db2?
What is the connection string to connect to the DB2 Database ?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is deadlock in db2?
What are types of indexes?
What is db2 bind?
Give the name of some fields form sqlca.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Mention the location where the output received from explain statement is stored.
Who uses db2?
Which component is responsible for processing sql statements and selecting access paths?
