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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is a plan and package in db2?
How to connect to db2 database from windows command line?
What is deadlock in db2?
Is it possible using max on a char column?
Mention the definition of cobol in varchar field.
What is the syntax for creating a table in the db2 database?
What parameters are used to control the free space in DB2?
What is phantom read in db2?
Define sqlca.
What is cascading rollback?
What is host variable?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain db2.