• Subject: Re: Ignore Data Decimal Errors
  • From: Buck Calabro/commsoft<mcalabro@xxxxxxxxxxxx>
  • Date: Thu, 11 Mar 1999 10:46:01 -0500

On 03/10/99 05:20:21 PM VENU YAMAJALA  wrote:

>I already compiled the ILE with FIXNBR(*ZONED). Let me explain what the 
>problem is -

This being an emergency, and the file not being a production file, and 
having only a few records, try FIXNBR(*INPUTPACKED)  You'll get a message 
in the joblog for every field that's invalid in every record you read.

If this were a production file, I'd test the data rather than let the 
system "fix" the number:

D                 DS 
D  AMLAD                  1      5P 0 
D  AMLADChar              1      5 

C                   TestN                   AMLADChar            979899

You can test for 3 conditions:
HI (97) - field contains numbers or it is a 1 char field containing A-R
LO (98) - field contains leading blank(s) and numbers
EQ (99) - field contains all blanks

Testing it yourself lets you print an error report so you can get the data 
provider to clean up the data before you get it.  If that's not feasable, 
at least having the report will tell your user that the problem hasn't 
changed.  What happens when the data provider has a problem and all the 
records have invalid data?  If you have an error report, your user will get 
100 pages instead of the 1 they're used to -- they will know that something 
has changed.  FIXNBR won't tell your user anything.

Buck Calabro
Billing Concepts Inc (formerly CommSoft), Albany, NY
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].