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 are catalog tables in db2?

0 Answers  


What is bind and rebind in db2?

0 Answers  


what are the SQL codes u freequently got?

2 Answers   Logica CMG,


define clustering index.

0 Answers  


What is a synonym? How is it used?

2 Answers  






what is + sign and -ve sign for sql code ?

1 Answers   TCS,


what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,


What do you need to do before you do EXPLAIN?

1 Answers  


how can u understand the end of the table ?

1 Answers   TCS,


What does db2 mean?

0 Answers  


What are the contents of a dclmgen?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  


Categories