Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ??

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

What parameters are used to control the free space in DB2?

0 Answers  


What is index in db2?

1 Answers  


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  


Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


What does an outer join do?

1 Answers   CTS,


what is difference between random and sequence file access

1 Answers   Syntel,


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


What is release/acquire in bind?

0 Answers  


what is db2 restart?

0 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,


Categories