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

Which component is responsible for processing sql statements and selecting access paths?

1172

What is temporal table in db2?

1097

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

1083

What is innodb buffer pool?

1127

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

1080

Is db2 a mainframe?

1091

What is the use of db2 optimizer?

1168

Define db2.

1160

How is the value function used?

1201

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1215

How do I add a column to an existing table in db2?

1079

What do you mean by rollback?

1027

Describe major components of db2?

1140

How to check sequence on a table in db2?

1110

What r the comman abends in db2, jcl and cobol???????

2307