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 are the contents of a dclmgen?

621


What is dclgen in db2?

667


What happens in bind step in a db2 program?

559


What is load utility in db2?

654


How do I copy a table in db2?

569






How to create db2 table in mainframe?

622


List out the buffer pools in db2

617


My sql statement select avg(salary) from emp yields inaccurate results. Why?

634


What is db2 instance?

587


Is ibm db2 free?

568


What is null value in db2?

556


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

735


What is cobol db2?

559


Name the lockable units in DB2?

656


What is a Foreign Key?

649