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
- 18939 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 do you eliminate duplicate values in db2?
What is null indicator in db2?
Explain about rct.
What is reorg?
What is a db2 table?
What is cursor in dbms?
What is the use of dclgen in db2?
What is buffer pool in the db2 database?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to find the number of rows in a db2 table?
What is copy pending status in db2?
How would the varchar column remarks defined?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How can deadlocks be resolved?
Are view updateable?
