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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How does db2 sample database connect?
Explain various types of locks in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How many databases can be created inside an instance in db2 ?
What is the difference between cursor and select statement?
What is the purpose of rollback and commit?
What is isolation level in db2?
Can you use max on a char column?
How does coalesce work?
Is db2 a database?
Which isolation level provides maximum concurrency?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is null indicator in cobol db2?
On which levels locks can be applied?