Can a unique index have more than one null value? If not,
what error code is given if an attempt is made to insert
more than one null value?
Answer Posted / mani
Unique index can have null values and no null value is equal
to another null value.
i don't know if it raises an error or not when you insert a
null value.
Null value acceptance in the column is again based on the
definition given for the column whether it can accept null
values or not.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Where do you specify them?
How to run db2 command in windows?
Which component is responsible for processing sql statements and selecting access paths?
What is a collection in db2?
Explain about open switch business continuity software?
Explain the contention situations caused by locks?
What is the maximum No of rows per page?
What is bufferpool in db2?
How many databases can be created inside an instance in db2 ?
What is copy pending status in db2?
Can we delete records from view?
What is image copy in db2?
What is the picture clause of null indicator variable?
Mention the different locking levels that are available in db2.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.