|
Angela,
When you try to do anything with the field, do you check to see if it is
null first?
I believe that even if you specify ALWNULL(*USRCTL), you still have to
check for null before using it.
I do something like this:
c if %nullind(fldname)
c eval %nullind(fldname) = *off
c eval fldname = *blanks ...(or 0)
c end
good luck,
Rick
--------original message---------
I have an ILE program that is reading files that were created with a
SQL script. Some of the fields in the file are null-capable. I have
compiled the program with *USRCTL on the allow null value field. This
USUALLY takes care of getting any errors for null fields. However once
in a while I will get a data mapping error within an ILE program while
reading a particular file. All I do is go into that file & record it
is bombing on and blank through any of the blank fields. Then
everything is fine. Why does it bomb out if I have used *USRCTL?
What can I do to prevent this?
Thankyou!!
Angela Wawrzaszek
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.