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 Posted / 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 |
Post New Answer View All Answers
How do I delete a table in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How would the varchar column remarks defined?
How to find schema of a table in db2?
What is a db2 tablespace?
What is runstats utility in db2?
Explain various types of locks in db2?
What is the difference between db2 and oracle?
What is db2 plan table?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
is it compulsory commitment control in journal?
How do you pull up a query which was previously saved in qmf?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a db2 table?
How to rename a table in DB2 ?