What if we fail to give values in columns declared as NOT
NULL ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mani
the above mentioned will happen provided there is no default
value specified at the time of defining the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santy_rathod007@yahoo.co.in
Please correct the above error defintation :-
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defiend as NOT NULL values.
| Is This Answer Correct ? | 2 Yes | 2 No |
Which component is responsible for db2 startup and shutdown?
What is a DB2 bind?
What is the role of union all and union
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Are views updateable?
What is SPUFI?
What is runstats db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a trigger in the db2 database?
Define buffer pool.
How does DB2 determine what lock-size to use?
can we view the access paths created by dbrm ? how ? thx