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 / 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 |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
How can you find out the # of rows updated after an update statement?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Can one database have multiple instances?
What is phantom read in db2?
What is a dbrm in db2?
Why do we need reorg in db2?
What os does db2 run on?
What is meant by union and union all?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is db2 instance?
What is declare cursor?
What is schema in db2?
What is the physical storage length of date data type?
What is buffer pool and list some of them?