when we specified NOT NULL WITH DEFAULT in the query ,the database will se

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

Question Posted / shankar

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

Please Help Members By Posting Answers For Below Questions

What is buffer pool in the db2 database?

1046

What is the maximum No of rows per page?

1011

How can you find out the # of rows updated after an update statement?

1050

What is the role of union all and union

1069

What is table space in db2?

959

How do we specify index to include or not during bind process.

2070

Define check constraint.

1025

How do I change the column size in db2?

1082

What is package in cobol db2?

1075

How to take backup of table in db2?

1021

Explain package in db2 and its advantages?

1134

Why cursor is used in db2?

985

What is view db2?

1004

Which component is responsible for processing sql statements and selecting access paths?

1070

What is difference between isnull and coalesce?

1006