Low values and Nulls

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

Hi,

How to check Low values and nulls in a file.

I know for Low values we have x'00', but if in millions of records i want to find records where a field say 'addr' has low values or null;

how we can find it through Fileaid?

If i have to find addr as 'xyz', i give 'xyz' against the field name, now suppose i expect it to be null or low values, then how will i check it?

Thanks

enrico-sorichetti · Posted: Fri Dec 04, 2009 4:01 pm

please review Your understanding of things....

the value of each byte ranges from x'00' to x'ff' and is just that... a value

nullness is not a value is a concept which means the absence of something,
in this case a value

to distinguish between low values and NULL value
every field must be defined os two tokens...
a flag and a value
the flag vill tell if the value has been assigned ( NOT NULL ) or not ( NULL)
so that You can process accordingly