Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

New crypt. See /usr/news/crypt.


computers / comp.sys.ibm.as400.misc / Re: Program to scan for Data Decimal Errors

SubjectAuthor
* Program to scan for Data Decimal ErrorsK M
`* Re: Program to scan for Data Decimal ErrorsJon Paris
 `* Re: Program to scan for Data Decimal ErrorsK M
  +- Re: Program to scan for Data Decimal ErrorsJon Paris
  `- Re: Program to scan for Data Decimal Errorssaitology9

1
Program to scan for Data Decimal Errors

<73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=98&group=comp.sys.ibm.as400.misc#98

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:620a:261f:b0:76d:3475:2de0 with SMTP id z31-20020a05620a261f00b0076d34752de0mr50919qko.8.1692281572615;
Thu, 17 Aug 2023 07:12:52 -0700 (PDT)
X-Received: by 2002:a17:903:32cd:b0:1bc:4452:59b6 with SMTP id
i13-20020a17090332cd00b001bc445259b6mr2222049plr.11.1692281572064; Thu, 17
Aug 2023 07:12:52 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!3.eu.feeder.erje.net!feeder.erje.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Thu, 17 Aug 2023 07:12:51 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:118c:2800:fc0f:d5c8:4390:c763;
posting-account=cuunowoAAAC-WC8RK_QIdPr_oknl0OsE
NNTP-Posting-Host: 2600:8801:118c:2800:fc0f:d5c8:4390:c763
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>
Subject: Program to scan for Data Decimal Errors
From: qwki...@gmail.com (K M)
Injection-Date: Thu, 17 Aug 2023 14:12:52 +0000
Content-Type: text/plain; charset="UTF-8"
 by: K M - Thu, 17 Aug 2023 14:12 UTC

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

Re: Program to scan for Data Decimal Errors

<4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=99&group=comp.sys.ibm.as400.misc#99

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:622a:1809:b0:410:6ea4:7416 with SMTP id t9-20020a05622a180900b004106ea47416mr31880qtc.1.1692371943499;
Fri, 18 Aug 2023 08:19:03 -0700 (PDT)
X-Received: by 2002:a05:6a00:2d09:b0:687:da95:a15c with SMTP id
fa9-20020a056a002d0900b00687da95a15cmr1366217pfb.5.1692371942951; Fri, 18 Aug
2023 08:19:02 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 18 Aug 2023 08:19:02 -0700 (PDT)
In-Reply-To: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=99.246.235.217; posting-account=M2CWQwkAAADWPUlV1hc8zQLJMu5PmOBW
NNTP-Posting-Host: 99.246.235.217
References: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com>
Subject: Re: Program to scan for Data Decimal Errors
From: jonbo...@partner400.com (Jon Paris)
Injection-Date: Fri, 18 Aug 2023 15:19:03 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Jon Paris - Fri, 18 Aug 2023 15:19 UTC

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.

Re: Program to scan for Data Decimal Errors

<d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=100&group=comp.sys.ibm.as400.misc#100

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:620a:618d:b0:76d:8151:e817 with SMTP id or13-20020a05620a618d00b0076d8151e817mr34627qkn.3.1692380053633;
Fri, 18 Aug 2023 10:34:13 -0700 (PDT)
X-Received: by 2002:a17:903:234c:b0:1b9:d335:1742 with SMTP id
c12-20020a170903234c00b001b9d3351742mr1288062plh.11.1692380053123; Fri, 18
Aug 2023 10:34:13 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!panix!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 18 Aug 2023 10:34:12 -0700 (PDT)
In-Reply-To: <4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:118c:2800:3079:832f:122f:1b0d;
posting-account=cuunowoAAAC-WC8RK_QIdPr_oknl0OsE
NNTP-Posting-Host: 2600:8801:118c:2800:3079:832f:122f:1b0d
References: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com> <4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>
Subject: Re: Program to scan for Data Decimal Errors
From: qwki...@gmail.com (K M)
Injection-Date: Fri, 18 Aug 2023 17:34:13 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1999
 by: K M - Fri, 18 Aug 2023 17:34 UTC

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.

Re: Program to scan for Data Decimal Errors

<36abe7ea-7fe3-4546-a138-5b5e741b6da1n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=101&group=comp.sys.ibm.as400.misc#101

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:6214:3905:b0:63c:edce:c71e with SMTP id nh5-20020a056214390500b0063cedcec71emr16013qvb.3.1692448789556;
Sat, 19 Aug 2023 05:39:49 -0700 (PDT)
X-Received: by 2002:a17:90a:ea8c:b0:26b:3e2a:52b0 with SMTP id
h12-20020a17090aea8c00b0026b3e2a52b0mr373446pjz.7.1692448789039; Sat, 19 Aug
2023 05:39:49 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Sat, 19 Aug 2023 05:39:48 -0700 (PDT)
In-Reply-To: <d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=99.246.235.217; posting-account=M2CWQwkAAADWPUlV1hc8zQLJMu5PmOBW
NNTP-Posting-Host: 99.246.235.217
References: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>
<4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com> <d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <36abe7ea-7fe3-4546-a138-5b5e741b6da1n@googlegroups.com>
Subject: Re: Program to scan for Data Decimal Errors
From: jonbo...@partner400.com (Jon Paris)
Injection-Date: Sat, 19 Aug 2023 12:39:49 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2349
 by: Jon Paris - Sat, 19 Aug 2023 12:39 UTC

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!

Re: Program to scan for Data Decimal Errors

<uik73p$2knkk$1@dont-email.me>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=108&group=comp.sys.ibm.as400.misc#108

 copy link   Newsgroups: comp.sys.ibm.as400.misc
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: saitolo...@gmail.com (saitology9)
Newsgroups: comp.sys.ibm.as400.misc
Subject: Re: Program to scan for Data Decimal Errors
Date: Thu, 9 Nov 2023 22:12:56 -0500
Organization: A noiseless patient Spider
Lines: 13
Message-ID: <uik73p$2knkk$1@dont-email.me>
References: <73488ac3-9b89-4eb3-9384-86b9164320d3n@googlegroups.com>
<4d20f2b2-9d13-4ab6-9a5d-9347e44c5169n@googlegroups.com>
<d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 10 Nov 2023 03:12:57 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="3c957f00b99d0c3aa6c9007d08ed70e0";
logging-data="2776724"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+9YXOMlbwxqi29pxjbKrtP"
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:uUGJpsZSpURz524g0rMaeeg3aPM=
Content-Language: en-US
In-Reply-To: <d12e5751-5242-4dfe-b592-e220855311c6n@googlegroups.com>
 by: saitology9 - Fri, 10 Nov 2023 03:12 UTC

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/

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor