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 catalog database in db2?

646

Is ibm db2 free?

579

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

595

What is universal database?

623

What is the use of value function?

629

What is dbrm library?

580

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10782

How to retrieve rows from a db2 table in embedded sql?

732

What is a trigger in the db2 database?

598

How do we specify index to include or not during bind process.

1674

What is the picture clause of null indicator variable?

694

How many databases can be created inside an instance in db2 ?

605

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

646

What is the difference between bind and rebind in db2?

858

How does cobol compile db2 program?

610