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
Why db2 is called db2?
Can we update view in db2?
Why do chiropractors use drop table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a buffer in memory?
Which component is used to execute the sql statements?
What is meant by dclgen?
How does db2 sample database connect?
Mention the location where the output received from explain statement is stored.
What is a db2 table?
What is the cobol picture clause of the db2 data types date, time, timestamp?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is ibm db2 database?
Is the primary key a clustered index?
