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

what is diffrence b/w file-aid tool and file-aid utility???

4331


Are view updateable?

711


Define db2.

757


What are foreign keys in db2?

703


What is temporal table in db2?

692






What r the comman abends in db2, jcl and cobol???????

1903


What are host variables in db2?

709


What is commit in db2?

687


How connect db2 database to datastage?

866


What is a db2 collection?

688


What is load replace in db2?

641


Which are the db2 tools to protect integrity of the database?

777


What is a collection in db2?

675


What is copy pending status in db2?

739


What is the purpose of using commit?

714