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
What is the max length of sqlca?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is ibm db2 connect?
Explain packages.
What are host variables in db2?
What are the bind parameters ibm db2?
What is the default page size of buffer pools?
Is db2 relational database?
What do you mean by commit and rollback?
What is the role of data manager in the db2 database?
Explain db2.
How many types of page locks can be held in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What does db2 blu stand for?
What is db2 purescale?