|
midrange.com
The last time I used CPYTOIMPF, it did not remove
trailing spaces. Admittedly, that was several years
ago - perhaps it has changed. But at the time, it was
a major problem (one of the fields in the file I was
converting was 32K varchar).
The options to CPYTOIMPF depend on your familiarity
with API's and calling Java, whether you prefer to do
something within or outside your comfort level, and
what you think you might need to know for the _next_
project.
I have used the write(), open(), close(), and
stat() API's called from ILE RPG (these are in the
Unix section of the API reference). If you want to
give these a shot, they do offer flexibility and
performance. I must admit that these API's were,
shall we say, not intuitive. (But, to quote Jon
Paris, you only have to be smart once when you code
something like this.)
If you do not feel like beating your head against
that particular wall, check out the ILE RPG
Programmer's Guide for the section on calling Java
from RPG.
Hope that helps,
Don
--- chris.delashmutt@xxxxxxxxxxxxx wrote:
>
>
>
>
> Would the CPYTOIMPF CL command be helpful to you?
> We use this to create
> CSV files quite a bit on our system. You could then
> write a small CL to do
> the multiple files for you.
>
> Here's an example of the command:
> CPYTOIMPF FROMFILE(YOURLIB/YOURFILE)
> TOSTMF('/an/ifs/path/test.csv')
> STMFCODPAG(*PCASCII) RCDDLM(*CRLF)
>
> Obviously, you should replace the YOURLIB/YOURFILE
> with the proper libary
> and file, and the /an/ifs/path/test.csv with a
> proper IFS path to spit the
> file out to.
>
> Chris DeLashmutt
> Senior R&D Analyst
> LeasePlan USA
> 1165 Sanctuary Pkwy., Alpharetta, GA 30004
> Phone: 678-202-8695
> Fax: 678-921-4895
> ClearCase problems? Check out the LeasePlan
> ClearCase FAQ for answers!
>
>
>
>
>
> "Gyenis, Karen"
>
>
> <Karen.Gyenis@bankofa
> To: java400-l@xxxxxxxxxxxx
>
> merica.com>
> cc:
>
> Sent by:
> Subject: FW: ILE VS. Java
>
> java400-l-bounces@mid
>
>
> range.com
>
>
>
>
>
>
>
>
> 03/14/2005 05:22 PM
>
>
> Please respond to
>
>
> Java Programming on
>
>
> and around the
>
>
> iSeries / AS400
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> > -----Original Message-----
> > From: Gyenis, Karen
> > Sent: Friday, March 11, 2005 4:33 PM
> > To: 'java400-l@xxxxxxxxxxxx'
> > Subject: ILE VS. Java
> >
> >
> > I have a data intensive job that runs
> in Visual Basic 6 and
> > needs to get off its current NT server
> platform.
> > We have an opportunity to rewrite it in
> ILE or Java.
> >
> > Does anyone know which one would be
> faster...?
> > Ups and Downs of either...?
> > It uses PF from AS/400 and generates
> 18 CSV files
> > for use by another application.
> >
> > I appreciate any suggestions -
> > Thank you - KG
> >
> --
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>
>
>
> "e-mail disclaimer:
> This message (including any attachments) is
> confidential and may be
> privileged. If you have received it by mistake
> please notify the sender by
> return e-mail and delete this message from your
> system. Any unauthorised
> use or dissemination of this message in whole or in
> part is strictly
> prohibited. Please note that e-mails are susceptible
> to change. LeasePlan
> Corporation N.V. (including its group companies)
> shall not be
> responsible nor liable for the proper and complete
> transmission of the
> information contained in this communication nor for
> any delay in its
> receipt or damage to your system. LeasePlan
> Corporation N.V.
> (or its group companies) does not guarantee that the
> integrity of this
> communication has been maintained nor that this
> communication is free
> of viruses, interceptions or interference."
>
> --
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>
>
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
