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 database manager in db2?

1066

What is temporal table in db2?

1101

How can deadlocks be resolved?

992

What are the contents of a dclmgen?

1176

What is reorg and runstats in db2?

1261

What is precompiler in db2?

1078

What is blu acceleration in db2?

1130

What language is db2 written in?

1104

Is ibm db2 open source?

1132

How to check last update on table in db2?

1100

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2223

Explain the contention situations caused by locks?

1145

Discuss about db2 bind?

1157

What is the difference between nvl and coalesce?

1108

How to find primary key of a table in db2?

1125