Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 19092 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
NOT NULL WITH DEFAULT indicates that the column cannot
contain a NULL, if a user doesnt enter a value, DB2
generates the default.
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / kumar
Using 'NOT NULL WITH DEFAULT' you can also specify you own
values. INTEGER, SMALLINT will assigned with zero, CHAR,
VARCHAR will be assigned with spaces. DATE, TIME, TIMESTAMP
will be assigned with system DATE, TIME & TIMESTAMPE values
respectively.
As the table is declared with 'NOT NULL WITH DEFAULT',
there is no chance of getting the null values during data
fetch.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / shankar
when we specified NOT NULL WITH DEFAULT in the query ,the
database will set the default values to that key eg. system
date ,time.
| Is This Answer Correct ? | 9 Yes | 10 No |
what is + sign and -ve sign for sql code ?
Is Cursor exicutable ?
What is explain plan in db2?
What is filter factor?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
what is SMP/E? and what are the major steps of it? thanks...
what is the use of commit ? and what is the syntax?
Which isolation level provides highest data integrity?
What does the CHECK Utility do ?
What is the use of commit in db2?
Explain transactions, commits and rollbacks in DB2.
What kind of database is db2?
COBOL 
