How to resolve -407 sql code in DB2?

Answer Posted / anandrao

This error occures when you are assigning NULL value to NOT
NULL column.
You can wrap the variable with coalesce/value and default
it but it is totally dependant on business logic.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do you specify them?

886


What is rebind in db2?

781


B37 abend during spufi?

1220


What is a page in db2?

805


What is null value in db2?

769


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

911


Why db2 is called db2?

779


What is declare cursor?

830


What is node in db2?

818


What types of tables are there in the db2 database?

809


Give a brief description of db2 isolation levels?

798


What is ibm db2 client?

698


What is concurrency?

919


What is difference between rollback and commit?

888


What is a db2 schema?

989