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
- 7798 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 |
What is db2 isolation?
what is the use of commit ? and what is the syntax?
What is reorg in DB2
what is parm utility
Can any one tell me about Restart logic in DB2.
List some fields from sqlca?
Is ibm db2 free?
How can we read records for specific member in CL? AND rpg?
Can there be more than one cursor open for any program?
What type of database is db2?
How do you run JCL in cobol program
List down the data types in the db2 database.
COBOL 
