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
Where can you declare a cursor in a cobol-db2 program?
How do you find the maximum value in a column in db2?
Mention some fields that are a part of sqlca.
What is page size in db2?
What is the role of schema in the db2 database?
What is commit in db2?
What is a cursor in programming?
What is package in cobol db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are catalog tables in db2?
What is meant by union and union all?
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
What is a page in db2?
What is rebind in db2?
What is db2 and what is the use of db2 optimizer?