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 |
Why db2 is called db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
max number of columns in a db2 table?
How do I create a view in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What are iseries servers?
When do you specify the isolation level?
How to get Top 10 Salaries from a Table
What is read-only cursor?
What is the error code -803 ?
How to find the maximum value in a column in the db2 database?
Can you use max on a char column?