What do you mean by NOT NULL? When will you use it?
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 |
Post New Answer View All Answers
What is the role of data manager in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is a bind in db2?
What is clone table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the connection string to connect to the DB2 Database ?
What are the full forms of spufi and dclgen and why are they used?
What is a dbrm in db2?
How is deadlock resolved?
What is sqlca’s maximum length?
what is the role of the cursor in db2?
define clustering index.
What is performance tuning db2?
What is the use of reorg in db2?