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
What is db2 look?
How can record locking be achieved in those DB2 versions which do not support it?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are catalog tables in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Highlight all the advantages that are attached to a package.
What is the difference between oracle and db2?
Which is faster delete or truncate?
How to find the maximum value in a column in the db2 database?
define clustering index.
What is a plan and package in db2?
Explain about cursor stability?
What is runstats db2?
i want to maintain uniqueness on pdf without make lf??????????
How to retrieve rows from a db2 table in embedded sql?