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.

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

What is the syntax for FETCH in DB2 ?

946


What is null in db2?

775


What are the contents of dclgen?

873


What are packages in db2?

811


What kind of database is db2?

801


When do you specify the isolation level?

811


Explain about open switch business continuity software?

859


What is the clustering index in the db2 database?

770


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11406


What is the physical storage length of timestamp data type?

876


How do you stop a db2 database in linux?

778


Which command is used to remove all rows from a table?

812


What is data manager?

824


How do you select a row using indexes in db2?

870


Is it possible using max on a char column?

889