Re: AS/400 Database File to IFS CSV Format

Bill,

You want the CPYTOIMPF command.

Neil Palmer         DPS Data Processing Services Canada Ltd.
                                             AS/400~~~~~
Markham,  Ontario,   Canada    ___________          ___  ~
Phone: (905) 474-4890  x303   |OOOOOOOOOO| ________  o|__||=
Cell.: (416) 565-1682  x303   |__________|_|______|_|______)
Fax:   (905) 474-4898          oo      oo   oo  oo   OOOo=o\
mailto:NeilP@DPSlink.com    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.DPSlink.com        AS/400e  The Ultimate Business Machine





"Reger, Bill" <breger@levitz.com>@midrange.com on 2000-08-03 16:52:56

Please respond to MIDRANGE-L@midrange.com

Sent by:  owner-midrange-l@midrange.com


To:   "'Midrange-L'" <MIDRANGE-L@midrange.com>
cc:

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