|
Hi Tim, Just a note -- *LOVAL is not the same as a null value. A field can contain *LOVALS and have its associated null indicator on or off. And *LOVAL has different values depending on the data type. For a date data type, *LOVAL is 0001-01-01, for a packed decimal 3.0 field, *LOVAL would be -999, and for a character 2a field, it would be x'0000'. If your date fields actually have x'00' in each byte, then it is an invalid date, and RPGLE will also have a problem with it, regardless of whether its null or not. Regards, Peter Dow Dow Software Services, Inc. 909 425-0194 voice 909 425-0196 fax From: "Hatzenbeler, Tim" <thatzenbeler@clinitech.net> > right now, I have null's in my data data types (lovals), and the sql, cann't > handle these... So I would like the program to at least keep functioning, > and then let me handle the nulls later when it comes to displaying them... _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
