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 load replace in db2?
What is a correlated sub query?
Explain about cursor stability?
How will you return the number of records in table?
If I have a view which is a join of two or more tables, can this view be updatable?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is the SQL Communications Area and what are some of its key fields?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
When Can you be sure that a query will return only one row?
What is db2 and what is the use of db2 optimizer?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?