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.



What if we try to insert the base table through updatable view , but failed to give a column value..

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

Post New Answer

More DB2 Interview Questions

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,


Which component is responsible for db2 startup and shutdown?

0 Answers  


What is the purpose of using commit?

0 Answers  


Name some fields from SQLCA

1 Answers  


Which isolation level provides maximum concurrency?

0 Answers  






What does db2 mean?

0 Answers  


What are the isolation levels possible ?

3 Answers  


What is the difference between nvl and coalesce?

0 Answers  


What is scrollable cursor in db2?

0 Answers  


How do you eliminate duplicate values in db2?

0 Answers  


What is ibm db2 connect?

0 Answers  


What is DCLGEN?

2 Answers  


Categories