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 / 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 |
can i code union in cobol-db2 pgm ?
How Plan is created while executing the query using SPUFI?
What is dbrm? What it contains?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
How do I delete a column in db2?
Explain about open switch business continuity software?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is cobol db2?
What is lock contention?
How do I connect my db2 database to ibm?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What are the various data types available in db2?