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


Please Help Members By Posting Answers For Below Questions

How would you find out the total number of rows in a db2 table?

803


Differentiate between cs and rr isolation levels? Where do you specify them?

844


How can the duplicate values be eliminated from db2 select?

883


What is bind in db2?

807


What is dclgen (declaration generator)?

829


What is commit in db2?

826


What is a dbrm in db2?

777


How to test SQL -911 error while developing COB-DB2 program

7120


How to find the number of rows in a db2 table?

873


What is node in db2?

826


What is dbrm? When it will be created?

789


How do you find the maximum value in a column in db2?

862


What is a db2 cursor?

821


What is dbrm? What it contains? When it will be created?

815


If I have a view which is a join of two or more tables, can this view be updateable?

914