Re: Performance when using POI to create an excel workbook.

Ted Holt has a really excellent book on using QShell at mc-press online.com and 
he has also published tons of QShell tips in the 400 Guru at IT Jungle. 

-----Original Message-----
    From: "as400tech@xxxxxxxxxxx"<as400tech@xxxxxxxxxxx>
    Sent: 2/20/06 9:16:00 AM
    To: "midrange-l@xxxxxxxxxxxx"<midrange-l@xxxxxxxxxxxx>
    Subject: Re: Performance when using POI to create an excel workbook.
    
    
    Here is the command I am using:
    
    SBMJOB CMD(QSH CMD('for jar in $(find
    /QIBM/UserData/Java400/ext/jakarta-poi-2.5.1/ -name ''*.jar''); do
    system "CRTJVAPGM CLSF(''"$jar"'') OPTIMIZE(40)";done'))
    
    No matter what path I use, I get the same error:
    
    "find: 001-0023 Error found opening file
    /QIBM/UserData/Java400/ext/jakarta-poi-2.5.1/. No such path or
    directory." 
    
    I know nothing about QSHELL so if someone can tell me what I am doing
    wrong, I would be truly greatful.
    
    Terry
    
    > message: 10
    > date: Fri, 17 Feb 2006 15:46:12 -0600 (CST)
    > from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
    > subject: Re: Performance when using POI to create an excel workbook.
    > 
    > 
    > > Scott & Leif,
    > > That's what I was afraid of. Hopefully one of these days the powers that
    > > be will decide to loosen the purse strings and upgrade the boxes.
    > 
    > One thing you might try (from that thread that Leif pointed to) is 
    > optimizing the JAR files.  That's a really good idea, it hadn't occurred 
    > to me.  Please read the thread for details:
    > 
    > http://sourceforge.net/forum/forum.php?thread_id=1374914&forum_id=500030
    > 
    > Let us know if that makes any difference -- I'd be very interested in how 
    > much difference it makes.
    > 
    > 
    
    
    -- 
    http://www.fastmail.fm - A fast, anti-spam email service.
    
    -- 
    This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
    To post a message email: MIDRANGE-L@xxxxxxxxxxxx
    To subscribe, unsubscribe, or change list options,
    visit: http://lists.midrange.com/mailman/listinfo/midrange-l
    or email: MIDRANGE-L-request@xxxxxxxxxxxx
    Before posting, please take a moment to review the archives
    at http://archive.midrange.com/midrange-l.