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 bind plan?
Which component is used to execute the sql statements?
What is consistency token in db2?
What is dbrm?
How do you eliminate duplicate values in db2?
What is the maximum size of varchar data type in db2?
What is the advantage in De-normalizing tables in DB2?
How is deadlock resolved?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Is it possible using max on a char column?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can you do the explain of a dynamic sql statement?
List out the three types of page locks that can be held.
what is diffrence b/w file-aid tool and file-aid utility???
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?