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 / sri
Null value will allow only one null (That is maximum) as
per DB2 stds. If we try to insert more we get error -305.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Mention some fields that are a part of sqlca.
What is the latest version of ibm db2?
is it compulsory commitment control in journal?
How to find primary key of a table in db2?
How to create backup table in db2?
What is buffer pool?
What is innodb buffer pool?
What is role in db2?
What is plan in cobol db2?
What is the maximum size of a char data type in db2?
What is db2 command?
How to rename a table in DB2 ?
What is the result of open cursor statement?
How do I add a column to a table in db2?
How do you find the maximum value in a column in db2?