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
- 19081 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
How can record locking be achieved in those DB2 versions which do not support it?
What is a storage group (stogroup)?
What is package in cobol db2?
What is difference between isnull and coalesce?
What is host variable in db2 cobol?
What is the role of data manager in the db2 database?
What are the rules for db2 programming?
Is ibm db2 free?
What is the purpose of using commit?
What are the contents of a dclmgen?
How to take backup of table in db2?
Is ibm db2 open source?
How to check table size in db2 sap?
What does db2 stand for?
Is db2 a database?
