Page 1 of 1

Is it Required to move the Null Indicators While Updating

PostPosted: Mon Oct 13, 2008 11:05 pm
by 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

Re: Is it Required to move the Null Indicators While Updating

PostPosted: Tue Oct 14, 2008 4:26 am
by 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.