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

What is a db2 table?

954

What is the role of data manager in the db2 database?

1051

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2123

Explain various types of locks in db2?

1081

What is bind and rebind in db2?

1072

Describe major components of db2?

1040

Which component is used to execute the sql statements?

1053

What is meant by union and union all?

948

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

What language is db2 written in?

980

What do you mean by between and in? Is between inclusive of specified range values?

1038

How will you return the number of records in table?

880

Define db2 and its databases?

1002

What is page size in db2?

906

When reorg is used?

1071