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

Can we insert update delete in view?

0 Answers  


What is coalesce in db2?

0 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


how can you access index

4 Answers   IBM, Tech Mahindra,


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,






If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  


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.

2 Answers   Syntel,


What are the two types of logging in the db2 database? Explain them.

0 Answers  


What is multi row fetch in db2?

0 Answers  


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?

4 Answers   CTS, IBM,


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


What is a synonym? How is it used?

2 Answers  


Categories