RE: Data conversion utility

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

It'll be pretty difficult to find a commercial data conversion application
that will map from "anything" to "anything" but if you know FMTDTA, you may
be surprised how flexible you can get.  Of course, that means you'll have to
spend oodles of time analysing each input and output column to make sure you
get the mapping correct.  In a previous life, we had computer operators do
some fantastic things with sort specs, which is why I mention it at all.

I'd stick with your current plan of using programmers and RPG.  Consider
simple DDS and CPYF *MAP as well (for the simple conversions.)

Buck 

> -----Original Message-----
> From: Dave Snyder 
> Sent: Tuesday, March 06, 2001 9:33 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Data conversion utility
> 
> I define "customer requirements" as any file record layout of data that
> the customer requires us to send to them or receive from them.
> 
> 
> Dave 
> 
> >>> "Leif Svalgaard" <leif@leif.org> 3/6/01 8:14:25 AM >>>
> 
> ----- Original Message -----
> From: Dave Snyder <dsnyder@blcnet.com>
> To: <MIDRANGE-L@midrange.com>
> Sent: Tuesday, March 06, 2001 6:50 AM
> Subject: Data conversion utility
> 
> 
> > We have need of some type of "easy to use" data conversion utility on
> the
> AS400. This product would be able to read in AS400 files (most likely
> files
> transferred from a p/c, like ACCESS or even comma delimited files), and
> manipulate the data to meet customer requirements
> 
> How do you express or describe "customer requirements" ?
+---
| 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
+---