[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Get CSV file
Hi,
you could use ftpapi to get the file and then use the System
i CPYFRMIMPF command to place the csv data into a PF.
Magne
>-----Original Message-----
>From: Janet Lopian [mailto:jlopian@xxxxxxxxxxxxx]
>Sent: Wednesday, January 9, 2008 06:19 PM
>To: ftpapi@xxxxxxxxxxxxxxxxxxxxxx
>Subject: Get CSV file
>
>Hi All,
>
>
>
>FTPAPI is GREAT! I do have a question about the get command. I need
to
>get a CSV file from a server and place it into an iSeries physical
file.
>The user will perform some maintenance duties on the file and then
put
>it back to the server. The get works well when I am using a flat
file.
>It does not work when the file contains more than one field. I think
>that I know the answer to this but I promised my boss that I would
ask:
>can the get command place a CSV file into a physical file with
multiple
>fields, in other words removing the commas and parsing the data into
the
>fields? The opposite would be needed with the put command.
>
>
>
>Thanks so much for your time!
>
>
>
>Jan
>
>
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------