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
5540 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 are union and union all?

976

What is the max length of sqlca?

1214

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1428

What is db2 bind?

1076

Explain about dbrm.

1037

Define sqlca.

1103

What is commit in db2?

1046

What do you mean by commit and rollback?

1032

What do you mean by rollback?

989

What is image copy in db2?

1010

Mention the various locks that are available in db2.

1034

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1233

Define db2.

1104

What is the clustering index in the db2 database?

1000

What is the use of runstats in db2?

1101