[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Get CSV file



   in case no one has mentioned it, this is handy as well:
   Replace null values . . . . . RPLNULLVAL *FLDDFT
   it prevents failures due to no value between the commas.
   "Stoicescu, Adriana" <astoicescu@xxxxxxxxxx> wrote:

     You are right.
     Adriana
     -----Original Message-----
     From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
     [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Francis
     Lapeyre
     Sent: Wednesday, January 09, 2008 1:03 PM
     To: HTTPAPI and FTPAPI Projects
     Subject: Re: Get CSV file
     I'm guessing that parameter (RMVBLANK) was added at V5R4, because
     I'm at
     V5R3 aand it isn't there.
     On Jan 9, 2008 2:10 PM, Stoicescu, Adriana
     wrote:
     > You can get rid of extra blank spaces generated by CPYTOIMPF by
     using
     > the parameter RMVBLANK.
     >
     >
     > Adriana
     >
     >
     > -----Original Message-----
     > From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
     > [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Craig
     > Jacobsen
     > Sent: Wednesday, January 09, 2008 11:00 AM
     > To: HTTPAPI and FTPAPI Projects
     > Subject: RE: Get CSV file
     >
     > Another thing you could do is parse the commas inside your
     program and
     > put them directly into your DB file. Same thing on the way out
     (better
     > than CPYTOIMPF, no extra blank spaces). This would also allow you
     to
     > validate the data and send an email to the user that all is ok or
     there
     > is an error with the data. Another thing you could use is HSSF to
     > write/read the spread sheet as an .xls instead of a .csv.
     >
     > HTH,
     >
     > Craig
     >
     > -----Original Message-----
     > From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
     > [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Steve
     L.
     > Sent: Wednesday, January 09, 2008 1:35 PM
     > To: HTTPAPI and FTPAPI Projects
     > Subject: Re: Get CSV file
     >
     > No, but you could use FTPAPI get the file and place it into a
     folder
     in
     > the IFS, then
     > subsequently use CPYFRMIMPF to copy the file from the IFS to the
     > database file, and
     > vice-versa.
     >
     > - steve
     >
     > ----- Original Message -----
     > From: "Janet Lopian"
     > To:
     > Sent: Wednesday, January 09, 2008 11:19 AM
     > 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
     > >
     >
     -------------------------------------------------------------------
     ----
     > >
     >
     >
     -------------------------------------------------------------------
     ----
     > This is the FTPAPI mailing list. To unsubscribe, please go to:
     > http://www.scottklement.com/mailman/listinfo/ftpapi
     >
     -------------------------------------------------------------------
     ----
     >
     > Confidentiality Notice: This e-mail message, including any
     attachments,
     > is for the sole use of the intended recipient(s) and may contain
     > confidential and privileged information. Any unauthorized review,
     use,
     > disclosure or distribution is prohibited. If you are not the
     intended
     > recipient, please contact the sender by reply e-mail and destroy
     all
     > copies of the original message. Unless expressly stated in this
     e-mail,
     > nothing in this message or any attachment should be construed as
     a
     > digital or electronic signature.
     >
     -------------------------------------------------------------------
     ----
     > This is the FTPAPI mailing list. To unsubscribe, please go to:
     > http://www.scottklement.com/mailman/listinfo/ftpapi
     >
     -------------------------------------------------------------------
     ----
     >
     >
     -------------------------------------------------------------------
     -----
     -------------
     > Email Confidentiality Notice and Disclaimer
     >
     > This email message contains information which may be confidential
     and
     > or legally privileged. Unless you are the intended recipient (or
     have
     > been authorised to receive on behalf of the intended recipient),
     you
     > may not use, copy or disclose to anyone the message or any
     information
     > contained in the message or from any attachments that were sent
     with
     > this email. If you have received this email message in error,
     please
     > advise the sender by email, and delete the message.
     >
     >
     >
     -------------------------------------------------------------------
     -----
     -------------
     >
     -------------------------------------------------------------------
     ----
     > This is the FTPAPI mailing list. To unsubscribe, please go to:
     > http://www.scottklement.com/mailman/listinfo/ftpapi
     >
     -------------------------------------------------------------------
     ----
     >
     --
     Francis Lapeyre
     Solum potestis prohibere ignes silvarum.
     -------------------------------------------------------------------
     ----
     This is the FTPAPI mailing list. To unsubscribe, please go to:
     http://www.scottklement.com/mailman/listinfo/ftpapi
     -------------------------------------------------------------------
     ----
     _________________________________________________________________

   Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
   [1]Try it now.

References

   1. http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------