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 cursor?
Is db2 a mainframe database?
Explain how can you do the explain of a dynamic sql statement?
What is buffrpool? Where we use it ?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What are the three DB2 date and time data types and their associated functions?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What are packages in db2?
What if we fail to give values in columns declared as NOT NULL ?
What is meant by isolation level?
What are types of indexes?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?