Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

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 the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / vijay

-805

Is This Answer Correct ?    3 Yes 1 No

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / dinesh

-84 unacceptable sql statement

Is This Answer Correct ?    0 Yes 0 No

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / rock

1)-206
2)-805
3)100

Is This Answer Correct ?    1 Yes 5 No

Post New Answer



More DB2 Interview Questions

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What is read-only cursor?

1 Answers  


what is SPUFI ?

2 Answers  


What is correlation names?

1 Answers  






Is it possible to precompile if db2 goes down?

4 Answers   Target,


What is difference between alias and synonym in db2?

0 Answers  


Define predicate?

0 Answers  


How many buffer pools are there in DB2?

2 Answers  


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,


What is the SQL Communications Area and what are some of its key fields?

1 Answers  






Categories