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
- 14180 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 are host variables in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is the default page size of buffer pools?
What is DYNSLT keyword? How do you perform selection using DYNSLT
wht happens if we close cursor with cursor with hold option?
How would one remove old reorg information from the DB2 catalog?
How do I delete a column in db2?
what is db2 restart?
What is page size in db2?
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 consistency token
COBOL 
