What if we try to insert the base table through updatable
view , but failed to give a column value which is defined
as NOT NULL.
Answer / santy
get error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defined as NOT NULL values.
| Is This Answer Correct ? | 11 Yes | 0 No |
What is dpf in db2?
What is ibm db2 connect?
what are the SQL codes u freequently got?
What is db2 bind process?
What is the purpose of rollback and commit?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
pls tell me abt the normalization five types....
cursor with hold explain ?
How to view db2 table structure?
What's the maximum number of characters that a tablename can have?
How do I delete a column in db2?
What is a SELECT statement?