What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
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 would you find out the total number of rows in a db2 table?
Differentiate between cs and rr isolation levels? Where do you specify them?
How can the duplicate values be eliminated from db2 select?
What is bind in db2?
What is dclgen (declaration generator)?
What is commit in db2?
What is a dbrm in db2?
How to test SQL -911 error while developing COB-DB2 program
How to find the number of rows in a db2 table?
What is node in db2?
What is dbrm? When it will be created?
How do you find the maximum value in a column in db2?
What is a db2 cursor?
What is dbrm? What it contains? When it will be created?
If I have a view which is a join of two or more tables, can this view be updateable?