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 role of data manager in the db2 database?

1111

If I have a view which is a join of two or more tables, can this view be updateable?

1139

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1150

What is a bind in db2?

1047

What is clone table?

1052

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What is the connection string to connect to the DB2 Database ?

1135

What are the full forms of spufi and dclgen and why are they used?

1091

What is a dbrm in db2?

1028

How is deadlock resolved?

1152

What is sqlca’s maximum length?

1195

what is the role of the cursor in db2?

1069

define clustering index.

1034

What is performance tuning db2?

1065

What is the use of reorg in db2?

1086