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

What is the physical storage length of time data type?

1077

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1019

What is the difference between bind and rebind in db2?

1404

What is bufferpool in db2?

995

What do you mean by between and in? Is between inclusive of specified range values?

1049

What is the difference between plan and package in db2?

1052

How do I delete a table in db2?

1017

What is explain plan in db2?

947

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

1128

Is db2 a database?

923

What is a trigger in the db2 database?

1026

How can we read records for specific member in CL? AND rpg?

656

What is cursor stability in db2?

1293

Before you give the explain statement, what are the prerogatives?

982

Give the name of some fields form sqlca.

1033