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
What is the maximum size of a char data type in db2?
What is the role of union all and union
How to find the number of rows in a db2 table?
How do I delete a column in db2?
How to check last update on table in db2?
How to fetch the last row from the table in SQL (db2)?
What r the comman abends in db2, jcl and cobol???????
What is the maximum size of varchar data type in db2?
What is the difference between nvl and coalesce?
What is the use of value function?
Is db2 a mainframe database?
What are the uses of db2 optimizer?
What is the reason behind not using select * in embedded sql programs?
How to execute stored procedure in db2 command editor?
When the like statement is used?