Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7919 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ratheesh
No. A SQLCODE of -803 (duplicate insert) will be returned.
| Is This Answer Correct ? | 0 Yes | 6 No |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
Can one database have multiple instances?
What is a Resource Control Table(RCT)? Describe its characteristics.
what is copy pending and check pending ?
How to take backup of table in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is page size in db2?
where can we use index and subscript ? with example ?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What type of database is db2?
What are host variables in db2?
What is syscat in db2?
COBOL 
