What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 17810 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm? What it contains?
Explain correlated sub-queries.
How do I start db2 in windows?
List out the buffer pools in db2
What is dbrm in db2 database?
Explain dclgen.
Explain what are the various isolation levels possible?
What is schema in db2?
What is load replace in db2?
How can deadlocks be resolved?
What is the role of schema in the db2 database?
How does db2 sample database connect?
What is commit in db2?
What is an instance in db2?
