No. Only these 3 values i.e 0, -1, -2 will be there in null indicator.

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?

Question Posted / manikanta

1 Answers
5560 Views
BNP Paribas, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is nvl in db2?

1109

What is query_cache_limit?

977

Can there be more than one cursor open for any program?

1177

How can you find out the # of rows updated after an update statement?

1116

What are the contents of a dclmgen?

1136

What is ibm db2 connect?

1008

How do you concatenate the firstname and lastname from emp table to give a complete name?

1078

What is db2 optimizer?

1256

What is rebind in db2?

1073

What is meant by explain?

1140

What is the difference between nvl and coalesce?

1069

What is alias in db2?

1070

Why cursor is used in db2?

1041

What is a storage group (stogroup)?

1252

What is cobol db2?

1007