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
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Who uses db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is db2 instance?
What is difference between rollback and commit?
What is the role of the data page in the db2 database?
How do I delete a column in db2?
How to check sequence on a table in db2?
Is db2 a programming language?
Define data page.
How do we specify index to include or not during bind process.
What are the 2 sqlcodes that are returned?
What is page size in db2?
What is db2 bind process?