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 db2 error codes -305 and -407. What is the
difference between these 2 error codes ?



What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?..

Answer / amarnadh reddy

Hi,
-305 is Null Indicator is needed. The null value cannot be
assigned to output host variable. Because no Indicator
variable is specified. (to fetch or select operation
resulted in the retrieval of a null value to be inserted
into the output host vaariable)

-407 is An update or insert value is null. but the object
column name cannot contain null values.(the update or insert
value was null. But the object column was declared as not
nullin the table)

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the purpose of the WHENEVER statement?

1 Answers  


What is the syntax required for the creation of a cursor?

1 Answers  


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


How can you compare table column after update and before update?

5 Answers   Satyam,


Give the COBOL definition of a VARCHAR field.

2 Answers  


How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  


What is db2 instance?

0 Answers  


What is the advantage in De-normalizing tables in DB2?

0 Answers  


How many sub queries can you combine together ?

4 Answers   IBM,


What are data types?

2 Answers  


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


What is db2?

0 Answers  


Categories