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