NOT NULL WITH DEFAULT indicates that the column cannot contain a NULL, if

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

Question Posted / s

Answer Posted / s

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

Please Help Members By Posting Answers For Below Questions

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

1068

What is the difference between bind and rebind in db2?

1404

How many types of page locks can be held in db2?

1000

Which command is used to remove all rows from a table?

1055

What action db2 takes when a program aborts in the middle of a transaction?

1104

What is view db2?

1019

What is node in db2?

998

What is the purpose of using commit?

1049

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1045

What is a db2 tablespace?

1009

What is the difference between oracle and db2?

1042

What is host variable in db2 cobol?

1036

What is check constraint in db2?

1020

Explain the function done by data manager?

1230

What is the default page size of buffer pools?

1081