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?



For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated ..

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

Post New Answer

More DB2 Interview Questions

What is cursor?

2 Answers  


Is db2 a mainframe database?

0 Answers  


Explain how can you do the explain of a dynamic sql statement?

0 Answers  


What is buffrpool? Where we use it ?

2 Answers   Tesco,


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?

1 Answers  


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.

1 Answers  


What are packages in db2?

0 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


What is meant by isolation level?

3 Answers  


What are types of indexes?

0 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


Categories