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 does runstats do in db2?

797


What is the maximum size of a char data type in db2?

798


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

981


How to resolve deadlock issue

19110


Mention some fields that are a part of sqlca.

812


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2317


What is syscat in db2?

794


How to check table size in db2 sap?

808


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

929


What is scrollable cursor in db2?

832


Can we update view in db2?

795


What is the physical storage length of timestamp data type?

885


What is an instance in db2?

804


What is explain in db2?

810


How to create backup table in db2?

877