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


Please Help Members By Posting Answers For Below Questions

Define buffer pool.

801


What is a db2 collection?

803


Can you tell me how can you find out the # of rows updated after an update statement?

868


When do you specify the isolation level?

794


What is an instance in db2?

768


What is a trigger in the db2 database?

806


How to test SQL -911 error while developing COB-DB2 program

7086


What is the role of union all and union

867


What are the various isolation levels possible?

857


is it compulsory commitment control in journal?

2223


What is dbrm? When it will be created?

775


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2544


What is meant by dclgen?

858


What is cursor in dbms?

838


Explain in brief how does db2 determine what lock-size to use?

787