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 do I start db2 in windows?

784


can we view the access paths created by dbrm ? how ? thx

6629


Is ibm db2 free?

748


What is db2 look?

769


What is the physical storage length of the data types date, time, and timestamp?

847


What are the various isolation levels possible?

835


List out the buffer pools in db2

808


What is commit in db2?

793


List down the types of triggers in the db2 database?

762


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

829


What does db2 blu stand for?

872


Why db2 is called db2?

762


How to find the number of rows in db2 tables?

788


What is multi row fetch in db2?

761


List out the data types available.

904