RE: AS/400 Database File to IFS CSV Format

use client access to download it to a PC as a CSV & then FTP it

-----Original Message-----
From: owner-midrange-l@midrange.com On Behalf Of Reger, Bill
Sent: Thursday, August 03, 2000 1:53 PM
To: 'Midrange-L'
Subject: AS/400 Database File to IFS CSV Format


I need to FTP an AS/400 database file to a PC at an outside firm and I would
like this process to be automated - no manual steps involved.  My problem is
not the FTP - that I can do easily - my problem is in the format.

Naturally the AS/400 file has packed numeric fields.  Since the file is
destined for use on a PC, we need to send the file in a CSV (comma
separated) format.  I thought about using the CPYTOSTMF command to get the
file to the IFS and then to FTP the file from the IFS.  But I don't see an
option on the CPYTOSTMF to convert the file to CSV on the way.  Anyone have
any ideas for me?

Thanks,  Bill

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com <mailto:breger@levitz.com> 
+---
| 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
+---



+---
| 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
+---