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
Are views updateable?
What is lock escalation in db2?
Which components manage deadlocks in db2?
Are view updateable?
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
How do I change the column size in db2?
What does a deadlock mean in DB2?
How do you pull up a query which was previously saved in qmf?
What does reorg do in db2?
Explain the function of data manager.
What is meant by dclgen?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is check constraint. Explain with example.
How does a cursor work?
Is the primary key a clustered index?
