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
How to execute stored procedures?
Who uses db2?
What are the various isolation levels possible?
On which levels locks can be applied?
How will you return the number of records in table?
What is the difference between drop table and delete table?
How do I copy a table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the advantage in De-normalizing tables in DB2?
How do I add a column to an existing table in db2?
What is role in db2?
Explain about cursor stability?
Define db2 and its databases?
What is the difference between plan and package in db2?
What is difference between alias and synonym in db2?