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 ??

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


Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

966


If I have a view which is a join of two or more tables, can this view be updateable?

1082


Why do we bind in db2?

1140


What is dclgen in db2?

1082


How do I delete a table in db2?

1006


What is view db2?

1004


How can you count the number of rows from a table tab?

1040


What is package in cobol db2?

1075


How do you eliminate duplicate values in db2?

1107


What is explain plan in db2?

941


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1135


Why do we need reorg in db2?

922


What is the syntax for FETCH in DB2 ?

1137


How do you concatenate the firstname and lastname from emp table to give a complete name?

1011


What is iseries database?

990