Re: Invalid decimal data

Hi Don,

If you have DBU, it has a facility for doing this.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Fisher, Don" <DRF@HeiligMeyers.com>
To: <midrange-l@midrange.com>
Sent: Monday, August 27, 2001 6:17 AM
Subject: Invalid decimal data


> We have a series of files, possible all of them, containing invalid
decimal
> data in some fields.  The only two ways I can think of to identify them
are
> to create an RPG program that will interrogate each field by executing a
> Z-ADD operation and checking the error indicator or to execute an SQL
> statement using each numeric field in the selection criteria.  The
statement
> should fail upon encountering invalid decimal data.  The trouble with the
> latter method is it won't allow me to fix the data.  At least I don't
think
> so.
>
> Does anyone out there know a more pleasant and convenient way to do this?
>
> Any help, as always, will be greatly appreciated.
>
> Donald R. Fisher, III
> Project Manager
> Heilig-Meyers Furniture Company
> (804) 784-7500 ext. 2124
> Don.Fisher@HeiligMeyers.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com