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 / ratheesh
No. A SQLCODE of -803 (duplicate insert) will be returned.
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is the difference between cursor stability and repeatable read isolation levels?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are the bind parameters ibm db2?
Mention the definition of cobol in varchar field.
What is a collection in db2?
What is the use of commit in db2?
What is the difference between using bind () and rebind () methods of naming class?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Is db2 a mainframe?
What is db2 look?
What is the picture clause of null indicator variable?
How do I import data from excel to db2?
What is consistency token in db2?
What is lock escalation in db2?
Explain how can you do the explain of a dynamic sql statement?