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
- 18757 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
What is db2 connect?
Mention data types used in db2 ?
What is db2 plan table?
Mention the definition of cobol in varchar field.
What are the prerogatives?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the maximum size of a char data type in db2?
How many databases can be created inside an instance in db2 ?
Define data page.
Before you give the explain statement, what are the prerogatives?
What is the physical storage length of time data type?
How to retrieve rows from a db2 table in embedded sql?
What is bind in db2?
What is a bind card?
What is a bind in db2?
