What if we fail to give values in columns declared as NOT
NULL ?
- 3 Answers
- 9055 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
define clustering index.
How to update more then one record using update?
What do you need to do before you do EXPLAIN ?
What is a bind card?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
How is a typical DB2 batch program executed ?
What is db2 instance?
What is null in db2?
What is the difference between Primary key and unique index?
What is the SQL Communications Area and what are some of its key fields?
Where would you find information about the type of database authority held by the user?
Before you give the explain statement, what are the prerogatives?
COBOL 
