IBM Mainframe Forum

[ninudvictor]

Hi,
There is a Table which has some Nullable columns and i need to update all columns of this table.
So is it required to move the Null Indicators of Nullable columns while updating?
Because without NI also,updation occurs fine without any difference.

Please let me know your views.

Thanks
Ninuninja

[dick scherrer]

Hello and welcome to the forum,

So is it required to move the Null Indicators of Nullable columns while updating?

I believe you need to review the way the NULL indicator functions.

Because without NI also,updation occurs fine without any difference.

If there is no difference, it may be because the test is not representative of all of the possible data. Keep in mind that NULL is not a data value - it is the absense of a value. NULL may only be identified external to the data field, not the content of the field.