Re: NULL's on the Iseries

[Mark Villa <iseries.4.me@xxxxxxxxx>]

>>What are some of the drawbacks of using NULL's?
 When using 3rd party files & programs and 4GL's it seems that this is when 
you don't have much choice when comparing values between files for fields 
that may be empty/initialized for a process and can be a development 
nightmare assuming not all files follow the same standard of field 
definition of "Allows the null value" Simple query to compare results or 
CMPPFM is useless.
 So I guess the moral of the story to me is know your data, know what your 
acquiring and know how to compare them, anticipating desired result set.