Is it Required to move the Null Indicators While Updating



IBM's flagship relational database management system

Is it Required to move the Null Indicators While Updating

Postby ninudvictor » Mon Oct 13, 2008 11:05 pm

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
ninudvictor
 
Posts: 7
Joined: Thu Oct 09, 2008 1:40 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby dick scherrer » Tue Oct 14, 2008 4:26 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post