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
5643 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 a db2 table?

1065

What is lock escalation in db2?

1080

Are view updateable?

1091

Explain correlated sub-queries.

1093

What's The Percentage Free Space ?

1282

What is db2 and what is the use of db2 optimizer?

1110

What is a page in db2?

1071

How does coalesce work?

1069

Explain the benefits you can get from mainframe connect?

1015

On which levels locks can be applied?

1200

Before you give the explain statement, what are the prerogatives?

1079

What is the difference between bind and rebind in db2?

1505

How to fetch the last row from the table in SQL (db2)?

1693

What is db2 bind?

1129

What are the contents of dclgen?

1160