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 ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find primary key of a table in db2?

1065


Is db2 free?

1094


How would you find out the total number of rows in a db2 table?

1051


What is catalog database in db2?

1162


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9197


Explain how can you do the explain of a dynamic sql statement?

1125


What is host variable in db2 cobol?

1077


What is the picture clause of null indicator variable?

1138


What is the difference between oracle and db2?

1107


What is reorg and runstats in db2?

1217


What is an instance database?

1052


Can you tell me how can you find out the # of rows updated after an update statement?

1101


Give a brief description of db2 isolation levels?

1072


What are foreign keys in db2?

1103


What happens in bind step in a db2 program?

970