|
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-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.