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

What is a bind card?

1281

How to get the ddl of a table in db2?

1170

What is image copy in db2?

1075

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1292

Mention the location where the output received from explain statement is stored.

1175

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

7673

Is ibm db2 open source?

1132

Discuss about db2 bind?

1157

What is copy pending and check pending in db2?

1046

What is the syntax for creating a table in the db2 database?

1150

What is buffer pool in the db2 database?

1159

How can you count the number of rows from a table tab?

1140

What is the reason behind not using select * in embedded sql programs?

1174

What is commit in db2?

1108

What is page size in db2?

1027