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

Is schema the same as database?

1006

What is coalesce in db2?

1055

What is bind package and plan in db2?

1005

What is dbrm? What it contains? When it will be created?

992

What is db2 stogroup?

1095

B37 abend during spufi?

1405

What is isolation level in db2?

942

What are union and union all?

920

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

1038

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1025

How is the value function used?

1080

What is rebind in db2?

999

what is the responsibility of the construction superintendent

2079

What are packages in db2?

972

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1228