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
Define buffer pool.
What is a db2 collection?
Can you tell me how can you find out the # of rows updated after an update statement?
When do you specify the isolation level?
What is an instance in db2?
What is a trigger in the db2 database?
How to test SQL -911 error while developing COB-DB2 program
What is the role of union all and union
What are the various isolation levels possible?
is it compulsory commitment control in journal?
What is dbrm? When it will be created?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is meant by dclgen?
What is cursor in dbms?
Explain in brief how does db2 determine what lock-size to use?