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
- 18785 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 do you mean by cursor?
When the like statement is used?
What is an instance in db2?
What type of database is db2?
What is sqlca’s maximum length?
What is null indicator in db2?
Give a brief description of db2 isolation levels?
What is db2 command?
What are the two types of logging in the db2 database? Explain them.
Explain about open switch business continuity software?
What is the maximum number of columns in a db2 table?
what is diffrence b/w file-aid tool and file-aid utility???
What is the function of logging in the db2 database?
What is null indicator in cobol db2?
How does a cursor work?
