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?
Answer Posted / ratheesh
No. A SQLCODE of -803 (duplicate insert) will be returned.
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is innodb buffer pool?
What is isolation level in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the difference between db2 and oracle?
Where can you declare a cursor in a cobol-db2 program?
Explain what are the various isolation levels possible?
what is the role of the cursor in db2?
How do you pull up a query which was previously saved in qmf?
Which is faster delete or truncate?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is catalog database in db2?
What is commit in db2?
Discuss about db2 bind?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is load utility in db2?