What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 5851 Views
- I also Faced
- E-Mail Answers
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
How can we read records for specific member in CL? AND rpg?
What is alias in db2?
List out the buffer pools in db2
What is query_cache_limit?
What is clone table?
What are the contents of a dclmgen?
What is reorg and runstats in db2?
What is ibm db2 used for?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is scrollable cursor in db2?
What is a db2 cursor?
Explain how can you do the explain of a dynamic sql statement?
What is dbrm in db2 database?
How to view db2 table structure?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
