How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes.

Answer Posted / yogesh

- 407 : Column in the table is defined as "NOT NULL", but
an INSERT or UPDATE is done to make the column as 'NULL'

-305 : Trying to FETCH or SELECT a null value from the
column of a table to a output host variable, which doesn't
have a null indicator declared for the host variable.

Is This Answer Correct ?    7 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by union and union all?

785


What is ibm db2 used for?

835


How do I connect my db2 database to ibm?

801


Highlight all the advantages that are attached to a package.

889


Is db2 a database?

746


Mention the different locking levels that are available in db2.

875


What is the use of commit in db2?

829


Is it possible to create an Instance in DB2 using DB2 Control Center ?

852


What is a page in db2?

803


What is runstats db2?

778


Name the various locking levels available?

839


What do you mean by between and in? Is between inclusive of specified range values?

876


What is the clustering index in the db2 database?

757


How can you classify the locks in db2?

839


What are host variables in db2?

821