what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
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 the difference between primary key & unique index ?
What is Declaration Generator(DCLGEN)?
Highlight all the advantages that are attached to a package.
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
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.
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Before you give the explain statement, what are the prerogatives?
Describe major components of db2?
What are the various isolation levels possible?