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?
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 correlation names?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is db2 instance?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
wht displays the number of times a query modified ?
What is the maximum No of rows per page?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is meant by dclgen?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is performance tuning db2?
Can one database have multiple instances?