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

1 Answers
6522 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I delete a table in db2?

1018

What is db2 catalog database?

995

Is db2 a programming language?

994

What is the role of schema in the db2 database?

1203

What is the use of predicate?

994

What is clone table?

1007

How do I change the column size in db2?

1098

Why db2 is called db2?

981

How can you do the explain of a dynamic sql statement?

1029

What is a db2 table?

969

What is host variable?

1024

Can you use max on a char column?

1040

What is cobol db2?

943

can all users have the privilage to use the sql statement select * (dml)?

1115

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1330