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
- 7662 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What are the uses of db2 optimizer?
What type of database is db2?
What is db2 instance?
What is buffer pool?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a page in db2?
What is deadlock in db2?
can all users have the privilage to use the sql statement select * (dml)?
Can you use max on a char column?
Name the various locking levels available?
How to check sequence on a table in db2?
What is the reason behind not using select * in embedded sql programs?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Explain about rct.
