get error code "-407" -407 :- An UPDATE, INSERT or SET VALUE i

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 / santy

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

Please Help Members By Posting Answers For Below Questions

How do I delete a table in db2?

1073

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

2852

How would the varchar column remarks defined?

1088

How to find schema of a table in db2?

1016

What is a db2 tablespace?

1066

What is runstats utility in db2?

1020

Explain various types of locks in db2?

1151

What is the difference between db2 and oracle?

1133

What is db2 plan table?

1050

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1102

is it compulsory commitment control in journal?

2478

How do you pull up a query which was previously saved in qmf?

1151

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

What is a db2 table?

1017

How to rename a table in DB2 ?

1088