What if we fail to give values in columns declared as NOT
NULL ?
Answer Posted / santy
we will get the sql error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column cannot contain the NULL values.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Why do we bind in db2?
Explain what are the various isolation levels possible?
What is the syntax for creating a table in the db2 database?
How do I connect my db2 database to ibm?
What's The Error Code For Unique Index Voilation?
Is ibm db2 open source?
What is db2 connect?
What is clone table?
What is the use of value function?
How will you return the number of records in table?
What is the physical storage length of date data type?
What is meant by union and union all?
How can we retrieve the total number of records in RPG & CLLE?
What is plan in cobol db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.