CREATE UNIQUE WHERE NOT NULL INDEX index1 ON table(column); WHERE NOT

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

Question Posted / s

Answer Posted / s

CREATE UNIQUE WHERE NOT NULL INDEX index1
ON table(column);

WHERE NOT NULL ensures that non-null values are unique.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain packages.

1118

What is a db2 collection?

1060

Is the primary key a clustered index?

1160

How do I add a column to an existing table in db2?

1040

What is the difference between cursor stability and repeatable read isolation levels?

1189

What is phantom read in db2?

1172

What is plan in cobol db2?

1150

What are the prerogatives?

1091

What is a bind in db2?

1052

Mention the different locking levels that are available in db2.

1146

What is a system catalog table in db2?

1198

What parameters are used to control the free space in DB2?

1067

What is db2 look?

1033

How to compare data between two tables in db2?

1096

What is cursor stability in db2?

1366