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
- 7774 Views
- I also Faced
- E-Mail Answers
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 |
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is consistency token in db2?
What is db2? Explain.
What is the function of logging in the db2 database?
What are the abend codes occour in ur latest PROJECT in DB2
What is the picture clause of null indicator variable?
What is reorg in database?
What is the syntax for creating a table in the db2 database?
How can we read records for specific member in CL? AND rpg?
where can we use index and subscript ? with example ?
Explain the use of the WHERE clause?
What is collection in db2 bind?
COBOL 
