What do you mean by NOT NULL WITH DEFAULT? When will you use it?

What do you mean by NOT NULL WITH DEFAULT? When will you
use it?

Question Posted / guest

3 Answers
17533 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What do you mean by NOT NULL WITH DEFAULT? When will you use it?..

NOT NULL WITH DEFAULT indicates that the column cannot
contain a NULL, if a user doesnt enter a value, DB2
generates the default.

Is This Answer Correct ?

20 Yes

1 No

What do you mean by NOT NULL WITH DEFAULT? When will you use it?..

Answer / 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

What do you mean by NOT NULL WITH DEFAULT? When will you use it?..

Answer / shankar

when we specified NOT NULL WITH DEFAULT in the query ,the
database will set the default values to that key eg. system
date ,time.

Is This Answer Correct ?

9 Yes

10 No

Post New Answer