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 reorg in DB2

3 Answers   Virtusa,


How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,


What are the three types of page locks that can be held?

1 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


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

2 Answers  


Explain db2.

0 Answers  


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


What is phantom read in db2?

0 Answers  


On which levels locks can be applied?

0 Answers  


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


What are the four lockable units for DB2?

1 Answers  


Categories