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
- 7670 Views
- I also Faced
- E-Mail Answers
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
Mention the location where the output received from explain statement is stored.
What is the difference between cursor and select statement?
How to resolve deadlock issue
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a dbrm in db2?
Which is faster delete or truncate?
Before you give the explain statement, what are the prerogatives?
What is the maximum length of sqlca?
How many types of page locks can be held in db2?
What are the bind parameters ibm db2?
what is the sqlcode -501
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What does reorg do in db2?
what is the role of the cursor in db2?
What is the default page size of buffer pools?
