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 to check sequence on a table in db2?

1068

What is the clustering index in the db2 database?

1005

What is access path in db2?

990

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

1156

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

1120

On which levels locks can be applied?

1144

What is a collection in db2?

1042

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1090

What are foreign keys in db2?

1110

How do you eliminate duplicate values in db2?

1201

define clustering index.

1036

Can we delete records from view?

972

Where can you declare a cursor in a cobol-db2 program?

1081

How do I start db2 in windows?

1104

How to find the number of rows in db2 tables?

1074