What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 18108 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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What do you mean by between and in? Is between inclusive of specified range values?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain package in db2 and its advantages?
Which component is responsible for db2 startup and shutdown?
What is the use of db2?
Which isolation level provides highest data integrity?
Before you give the explain statement, what are the prerogatives?
What is the difference between nvl and coalesce?
What is load utility in db2?
How many types of page locks can be held in db2?
Can we insert update delete in view?
What is reorg?
What is the difference between bind and rebind in db2?
How to access db2 tables in mainframe?
