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
- 7699 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 does it mean if the null indicator has -1, 0, -2?
What is the command used by TSO users to invoke DB2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do I add a column to a table in db2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Can a Db2 table data be retrived through JCL?
How to find last record before record through SQLRPGLE?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a host variable?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What does DSNDB07 database do?
COBOL 
