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

Where can you declare a cursor in a cobol-db2 program?

604


How do you find the maximum value in a column in db2?

650


Mention some fields that are a part of sqlca.

603


What is page size in db2?

563


What is the role of schema in the db2 database?

653






What is commit in db2?

596


What is a cursor in programming?

596


What is package in cobol db2?

704


My sql statement select avg(salary) from emp yields inaccurate results. Why?

643


What are catalog tables in db2?

609


What is meant by union and union all?

589


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1597


What is a page in db2?

611


What is rebind in db2?

576


What is db2 and what is the use of db2 optimizer?

655