- I still think it should be possible to run several jobs that all use Java without it locking up.
starting lots of JVMs stays very poor design and will burn down any as400 - maybe it might make IBM happy (or the custumor pulls out the plug of the as400)
- There is more than one right way - in this case, the right way is call SQL2JXL again and again in the same program - I believe that once there is a JVM in a job, that it doesn't do anymore initialization.
that won't help, even using pase it stays very poor design to start a JVM over and over again to do only little work. BTW: starting a JVM is most expensive on AS/400!!!
- So I really want to get away from the Java-based solution completely and go to using CGIDEV2 to write OpenXML - trouble that I have is, getting an image into the worksheet - saving to 2003 XML format doesn't preserve the image.
That's another work around with very little flexibility. It's absolutely no problem to use all Java tools of the world on AS/400 too, doing it the right way!!!
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact