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 db2 look?

1018

How can record locking be achieved in those DB2 versions which do not support it?

1072

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1050

What are catalog tables in db2?

1041

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1079

Highlight all the advantages that are attached to a package.

1109

What is the difference between oracle and db2?

1094

Which is faster delete or truncate?

1121

How to find the maximum value in a column in the db2 database?

1066

define clustering index.

1016

What is a plan and package in db2?

1093

Explain about cursor stability?

1040

What is runstats db2?

1012

i want to maintain uniqueness on pdf without make lf??????????

2151

How to retrieve rows from a db2 table in embedded sql?

1379