[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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 <[1]astoicescu@xxxxxxxxxx>
wrote:
You can get rid of extra blank spaces generated by CPYTOIMPF by
using
the parameter RMVBLANK.
Adriana
-----Original Message-----
From: [2]ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
[mailto:[3]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: [4]ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
[mailto:[5]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" <[6]jlopian@xxxxxxxxxxxxx>
To: <[7]ftpapi@xxxxxxxxxxxxxxxxxxxxxx >
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:
> [8]http://www.scottklement.com/mailman/listinfo/ftpapi
>
----------------------------------------------------------------------
-
>
----------------------------------------------------------------------
-
This is the FTPAPI mailing list. To unsubscribe, please go to:
[9]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:
[10]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:
[11]http://www.scottklement.com/mailman/listinfo/ftpapi
----------------------------------------------------------------------
-
--
Francis Lapeyre
Solum potestis prohibere ignes silvarum.
References
1. mailto:astoicescu@xxxxxxxxxx
2. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
3. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
4. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
5. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
6. mailto:jlopian@xxxxxxxxxxxxx
7. mailto:ftpapi@xxxxxxxxxxxxxxxxxxxxxx
8. http://www.scottklement.com/mailman/listinfo/ftpapi
9. http://www.scottklement.com/mailman/listinfo/ftpapi
10. http://www.scottklement.com/mailman/listinfo/ftpapi
11. 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
-----------------------------------------------------------------------