RE: AS/400 Database File to IFS CSV Format

CPYTOIMPF is the one you want.  If you don't have the (relatively) recent
ptfs you may have to create the destination file(s) on the target machine
using a text editor or any convenient method to avoid code page problems,
otherwise use *PCASCII for the stream file code page parameter.  If your
version of the command doesn't have the ptfs, the stream file code page
parameter won't be available.

> -----Original Message-----
> From: Reger, Bill [mailto:breger@levitz.com]
> 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
+---