RE: AS/400 Database File to IFS CSV Format

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

Well...not "target machine," but in the IFS directory.  Sorry.

> -----Original Message-----
> From: Joel Fritz [mailto:JFritz@sharperimage.com]
> Sent: Thursday, August 03, 2000 3:52 PM
> To: 'MIDRANGE-L@midrange.com'
> Subject: 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
> +---
> 
+---
| 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
+---