1. Forum
  2. Usenet
  3. COMP.SYS.IBM.AS400.MISC

  • Program to scan for Data Decimal Errors

    From K M@21:1/5 to All on Thu Aug 17 07:12:51 2023
    Hello All;

    Does anyone know of a program which can scan all numeric files in all physical files within a library and report any found data decimal errors? I have a client who asked about such a program.

    There are programs that can scan a single field in a single file but I haven't come across a program that can scan all numeric fields in every physical file within a library.

    Many Thanks.

    KM

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jon Paris@21:1/5 to K M on Fri Aug 18 08:19:02 2023
    On Thursday, August 17, 2023 at 10:12:54 AM UTC-4, K M wrote:
    Hello All;

    Does anyone know of a program which can scan all numeric files in all physical files within a library and report any found data decimal errors? I have a client who asked about such a program.

    There are programs that can scan a single field in a single file but I haven't come across a program that can scan all numeric fields in every physical file within a library.

    Many Thanks.

    KM
    Well IBM offers this solution: https://www.ibm.com/support/pages/correcting-decimal-data-errors

    A more comprehensive approach can be found in the discussions in and on Simon's piece here: https://www.rpgpgm.com/2015/04/coping-with-data-decimal-error-when.html - the comments reference a piece I wrote fro ITJungle.

    It really depends on whether you want to know which fields in which records are in error and how you want to fix them.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From K M@21:1/5 to All on Fri Aug 18 10:34:12 2023
    Thanks for the response Jon.

    The customer basically wants to scan every numeric field in a choice of physical files looking for data decimal errors; whether that be *ALL files across *ALL libs or any combination thereof down to a single file. I suppose if a program exists that
    scanned and produced RNQ0907, then output with the file and field names along with RRNs would be enough.

    He didn't go into details about how he wants the field values corrected. Only reporting them for now.

    Simon's RPGPGM.COM example is close and I'll pass it along to the customer. BTW, I never thought how useful a program like this could be. The customer's request seems quite reasonable.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jon Paris@21:1/5 to K M on Sat Aug 19 05:39:48 2023
    On Friday, August 18, 2023 at 1:34:15 PM UTC-4, K M wrote:
    Thanks for the response Jon.

    The customer basically wants to scan every numeric field in a choice of physical files looking for data decimal errors; whether that be *ALL files across *ALL libs or any combination thereof down to a single file. I suppose if a program exists that
    scanned and produced RNQ0907, then output with the file and field names along with RRNs would be enough.

    He didn't go into details about how he wants the field values corrected. Only reporting them for now.

    Simon's RPGPGM.COM example is close and I'll pass it along to the customer. BTW, I never thought how useful a program like this could be. The customer's request seems quite reasonable.
    It is a reasonable request as long as they intend to do something about theroot cause. The crritical thing is to use information from programs such as these toghether with journal entries to establish the programs in error and fix them!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From saitology9@21:1/5 to K M on Thu Nov 9 22:12:56 2023
    On 8/18/2023 1:34 PM, K M wrote:
    Thanks for the response Jon.

    The customer basically wants to scan every numeric field in a choice of physical files looking for data decimal errors; whether that be *ALL files across *ALL libs or any combination thereof down to a single file. I suppose if a program exists that
    scanned and produced RNQ0907, then output with the file and field names along with RRNs would be enough.

    He didn't go into details about how he wants the field values corrected. Only reporting them for now.


    Check out this solution by saitology campaign. It addresses all of your requirements and then some:

    https://www.reddit.com/r/IBMi/comments/17ru8vo/decimal_data_errors_on_ibm_i/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)