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 |
Can we insert update delete in view?
What is coalesce in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
how can you access index
What is the specific need of Plan and..where are the tables in DB2 are physically saved
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What are the two types of logging in the db2 database? Explain them.
What is multi row fetch in db2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What does CURRENTDATA option in bind indicate
What is a synonym? How is it used?