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

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

5 Answers   Satyam,


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


Update command

1 Answers  


how to resolve -811 error. give clear explination

4 Answers   IBM,


How does DB2 use multiple table indexes?

1 Answers  


What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,


What is null indicator in db2?

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


What's The Percentage Free Space ?

0 Answers   IBM,


What are the advantages of using a PACKAGE?

2 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


Categories