|
The niftiest thing I did was write a command CVTXLS to dump any file into
an Excel spreadsheet (Thank you Scott, your service program made it much
easier).
This brought up a problem with AS/400 JVM that I haven't been able to
overcome. The first file I attempted to dump was a 119 column, 225,000 rows.
It ran for 36 hours and only processed 40,000 records. Used too much memory.
Towards the end the garbage cleanup function was being called every time a
Java call was executed and was taking longer and longer. I finally had to
cancel the program. The program ran alright when I limited the file to
15,000 records and started another spreadsheet.
Marvin
------------------------------
message: 6
date: Thu, 8 Jan 2009 14:45:37 -0500
from: Alan Shore <AlanShore@xxxxxxxx>
subject: Re: FW: Niftiest thing(s) you have done in RPG ILE or /FREE
Small, teeny, tiny, litle-itty bit programs
Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx <E%3AAShore@xxxxxxxxxxx>
P:(631) 200-5019
C:(631) 880-8640
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
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.