Re: Identifying Numeric Columns with Bad Data - S36 DDS Conversion

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Richard,
Good finding those services.  However, they do not look like they were
built to handle S/36 flat files either.
IDK if you could make a LF over them, with the appropriate substringing and
conversions, and then run those services against that.

On Mon, Mar 16, 2026 at 10:44 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> map/drop doesn't make sense for a S/36 flat file
>
> On Mon, Mar 16, 2026 at 10:41 AM stefan@xxxxxxxxxx <stefan@xxxxxxxxxx>
> wrote:
>
> > I would expect a cpyf  fmtopt(*map *drop) to find errors as well....
> >
> >
> > Best regards
> >
> >
> >
> > Stefan
> >
> >
> >
> > --
> >
> > No trees were killed in the sending of this message, but a large number
> > of electrons were terribly upset.
> >
> >
> >
> > Stefan Tageson
> >
> > +46 732 369934
> >
> > stefan@xxxxxxxxxx<mailto:stefan@xxxxxxxxxx>
> >
> >
> >
> > ________________________________
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
> > Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
> > Sent: Monday, March 16, 2026 15:29
> > To: midrange-l@xxxxxxxxxxxxxxxxxx <midrange-l@xxxxxxxxxxxxxxxxxx>
> > Subject: Identifying Numeric Columns with Bad Data - S36 DDS Conversion
> >
> > Hi All,
> >
> > Doing a S36 conversion to add DDS/DDL to tables.
> >
> > Is there a good methodology to check for decimal data errors on columns
> > and fix them quickly ?
> >
> > We do a CPYF *NOCHK to populate the tables.
> >
> > And I’ve seen SQL function “systools.validate_data” as one possible
> > method.
> >
> > Thoughts appreciated.
> >
> > Regards,
> > Richard Schoen
> > Web: http://www.richardschoen.net
> > Email: richard@xxxxxxxxxxxxxxxxx
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.