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 |
What is cloudant database?
What is cursor stability in db2?
What is a NULL value? What are the pros and cons of using NULLS?
Give the COBOL definition of a VARCHAR field.
How to retrieve rows from a db2 table in embedded sql?
cursor with hold explain ?
What does the sqlcode of -818 pertain to?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do you insert a record with a nullable column?
What is the purpose of rollback and commit?
My SQL is not performing well. Describe how will you fine tune it?