What if we try to insert the base table through updatable view , but failed to

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.

Question Posted / mangesh

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

More DB2 Interview Questions

What is a db2 tablespace?

what is Runstats? Whem will u choose to runatats?

How do I optimize a query in db2?

What is a lock?

On which levels locks can be applied?

What is cursor stability in db2?

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

Is DECLARE TABLE in DCLGEN necessary? Why it used?

What is dbrm? What it contains? When it will be created?

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

What is db2 and what is the use of db2 optimizer?

For more DB2 Interview Questions Click Here