What if we fail to give values in columns declared as NOT
NULL ?
Answer Posted / santy
we will get the sql error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column cannot contain the NULL values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is database manager in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
Define db2 and its databases?
How to rename a table in DB2 ?
How can you do the explain of a dynamic sql statement?
What is db2 plan table?
What is difference between alias and synonym in db2?
What is performance tuning db2?
What are foreign keys in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is db2?
Is ibm db2 free?
What is the difference between bind and rebind in db2?
How is deadlock resolved?
Why db2 is called db2?