For Null indicator we have 3 values 0,-1,-2.
0->Not nulll
-1->Null
-2->Value truncated
If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
Answer / manikanta
No. Only these 3 values i.e 0, -1, -2 will be there in null indicator.
Is This Answer Correct ? | 4 Yes | 2 No |
What is the use of runstats in db2?
What is an alias?
How do you Load a table ?? and what is Load replace ?
What is the use of db2?
What's the maximum number of volumes that can be added to a STOGROUP?
Mention the location where the output received from explain statement is stored.
What is universal database?
How many clustering indexes can be defined for a table?
What is the result of open cursor statement?
What is a DBRM, PLAN ?
Which one allows duplicate values Union or Union All ?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?