RE: AS/400 Database File to IFS CSV Format

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

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