|
midrange.com
Gary,
Sorry, all it's got is this:
Work with Job Spooled Files
Job: JPDLHS2 User: SCESSNA Number: 788748
Type options, press Enter.
1=Send 2=Change 3=Hold 4=Delete 5=Display 6=Release 7=Messages
8=Attributes 9=Work with printing status
Device or Total Current
Opt File Queue User Data Status Pages Page Copies
QPJOBLOG QEZJOBLOG JPDLHS2 RDY 3 1
Bottom
Parameters for options 1, 2, 3 or command
===>
F3=Exit F10=View 3 F11=View 2 F12=Cancel F22=Printers F24=More
keys
Shane Cessna
iSeries Programmer
iSeries WAS Administrator
North American Lighting, Inc.
(618) 662-4483 x2776
shane_cessna@xxxxxxx
"Gary L Peskin" <garyp@xxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
05/26/2005 01:26 PM
Please respond to
Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
To
"'Java Programming on and around the iSeries / AS400'"
<java400-l@xxxxxxxxxxxx>
cc
Subject
RE: Jakarta POI HSSF question...
They should be spool files with the batch job. Try doing a WRKSBMJOB and
then selecting the job and then option 4.
Gary
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Shane_Cessna@xxxxxxx
> Sent: Thursday, May 26, 2005 10:58 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Jakarta POI HSSF question...
>
> Gary,
>
> How do I go about accessing these spool files?
>
> Shane Cessna
> iSeries Programmer
> iSeries WAS Administrator
> North American Lighting, Inc.
> (618) 662-4483 x2776
> shane_cessna@xxxxxxx
>
>
>
> "Gary L Peskin" <garyp@xxxxxxxxxxxx>
> Sent by: java400-l-bounces@xxxxxxxxxxxx
> 05/26/2005 09:55 AM
> Please respond to
> Java Programming on and around the iSeries / AS400
> <java400-l@xxxxxxxxxxxx>
>
>
> To
> "'Java Programming on and around the iSeries / AS400'"
> <java400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> RE: Jakarta POI HSSF question...
>
>
>
>
>
>
> It would be helpful if we could see the full stack trace for
> the IOException. There should be spool files created for
> System.err and System.out that would show this.
>
> Gary
>
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > Shane_Cessna@xxxxxxx
> > Sent: Thursday, May 26, 2005 7:01 AM
> > To: Java Programming on and around the iSeries / AS400
> > Subject: RE: Jakarta POI HSSF question...
> >
> > I've even tried hardcoding the .xls file name and
> spreadsheet name and
> > still get the same results...
> >
> > /free
> > hssf_begin_object_group(100);
> > monitor;
> > book =
> hssf_open('/home/scessna/excel/May05DailyLaborHours2.xls');
> > monitor;
> > spreadsheet = hssf_getSheet(book:'May 25');
> > if spreadsheet = *null;
> > spreadsheet = HSSF_newSheet(book:'May 25');
> > endif;
> > on-error;
> > spreadsheet = HSSF_newSheet(book:'May 25');
> > endmon;
> > on-error;
> > book = new_HSSFWorkbook();
> > spreadsheet = HSSF_newSheet(book:'May 25'); endmon;
> > HSSF_save(book:'/home/scessna/excel/May05DailyLaborHours2.xls');
> > hssf_end_object_group();
> > *inlr = *on;
> > /end-free
> >
> > Shane Cessna
> > iSeries Programmer
> > iSeries WAS Administrator
> > North American Lighting, Inc.
> > (618) 662-4483 x2776
> > shane_cessna@xxxxxxx
> >
> >
> >
> > michael@xxxxxxxxxxxxxxxxxx
> > Sent by: java400-l-bounces@xxxxxxxxxxxx
> > 05/26/2005 08:43 AM
> > Please respond to
> > Java Programming on and around the iSeries / AS400
> > <java400-l@xxxxxxxxxxxx>
> >
> >
> > To
> > Java Programming on and around the iSeries / AS400
> > <java400-l@xxxxxxxxxxxx> cc
> >
> > Subject
> > RE: Jakarta POI HSSF question...
> >
> >
> >
> >
> >
> >
> > What's the actual error? What does %status show? See
> anything in the
> > job log?
> >
> > > -------- Original Message --------
> > > Subject: RE: Jakarta POI HSSF question...
> > > From: Shane_Cessna@xxxxxxx
> > > Date: Thu, May 26, 2005 9:35 am
> > > To: Java Programming on and around the iSeries / AS400
> > > <java400-l@xxxxxxxxxxxx>
> > >
> > > sorry guys, I tried that in the CL...still get the same
> > results...if it
> > > helps, here's my source...the hssf_h & HSSF binding
> > direcotry is the
> > stuff
> > > that Scott Klement put in a few Club Tech newsletters for
> > >
> > iSeriesNetwork.com...http://www.iseriesnetwork.com/noderesourc
> > es/code/clubtechcode/ExcelCrtDemo.zip
> > >
> > > JPTESTC2 - CLP
> > > PGM
> > > CHGCURDIR DIR('/')
> > > ADDENVVAR ENVVAR(CLASSPATH) +
> > > VALUE('.:QIBM/UserData/Java400/ext/poi-2.5.+
> > > 1-final-20040804.jar') REPLACE(*YES)
> > > CALL PGM(JPTEST2)
> > > ENDPGM
> > >
> > > JPTEST2 - RPGLE
> > > h dftactgrp(*no) bnddir('HSSF') thread(*serialize) h
> > > option(*srcstmt:*nodebugio:*noshowcpy) bnddir('QC2LE') /copy
> > > qsysinc/qrpglesrc,jni /copy qrpglesrc,hssf_h
> > > //---------------------------------------------
> > > // Data Structures
> > > //---------------------------------------------
> > > d ds
> > > dmonthsshort 48a Inz('Jan +
> > > d Feb +
> > > d Mar +
> > > d Apr +
> > > d May +
> > > d Jun +
> > > d Jul +
> > > d Aug +
> > > d Sep +
> > > d Oct +
> > > d Nov +
> > > d Dec ')
> > > dmonthshort 4a dim(12) overlay(monthsshort)
> > > d ds
> > > d year4 1 4 0
> > > d year2a 2a overlay(year4:3)
> > > //---------------------------------------------------------------
> > > // Standalones & Constants
> > > //---------------------------------------------------------------
> > > d book s like(HSSFWorkbook)
> > > d spreadsheet s like(HSSFSheet)
> > > d enddate s d
> > > d endday s 2p 0
> > > d dayname2 s 6a varying
> > > d attachment s 50a
> > > //------------------------------------------------------------
> > > // Mainline
> > > //------------------------------------------------------------
> > > /free
> > > enddate = %date() - %days(1);
> > > endday = %subdt(enddate:*days);
> > > year4 = %subdt(enddate:*years);
> > > hssf_begin_object_group(100);
> > > attachment = '/home/scessna/excel/' +
> > > %trim(monthshort(%subdt(enddate:*months))) +
> > > %trim(year2a) + 'DailyLaborHours2.xls';
> > > dayname2 = %trim(monthshort(%subdt(enddate:*months))) + ' ' +
> > > %char(endday);
> > > monitor;
> > > book = hssf_open(%trim(attachment)); <-- this never
> > gets found &
> > > jumps to the on-error
> > > monitor;
> > > spreadsheet = hssf_getSheet(book:%trim(dayname2));
> > > if spreadsheet = *null;
> > > spreadsheet = HSSF_newSheet(book:%trim(dayname2));
> > > endif;
> > > on-error;
> > > spreadsheet = HSSF_newSheet(book:%trim(dayname2));
> > > endmon;
> > > on-error;
> > > book = new_HSSFWorkbook();
> > <-- here is
> > > where it jumps to...
> > > spreadsheet = HSSF_newSheet(book:%trim(dayname2));
> > > endmon;
> > > HSSF_save(book:%trim(attachment));
> > > hssf_end_object_group();
> > > *inlr = *on;
> > > /end-free
> > >
> > > if you guys can find anything wrong with my code, please let me
> > > know...thanks again...
> > >
> > > Shane
> > >
> > >
> > > Hi,
> > >
> > > here is what I do in a CL before I call the RPGLE (with Jakarta
> > > POI):
> > >
> > > CHGCURDIR DIR('/jakartapoi')
> > > ADDENVVAR ENVVAR(CLASSPATH) +
> > > VALUE('.:/jakartapoi:/jakartapoi/jakartapoi151.jar') +
> > > REPLACE(*YES)
> > >
> > > Regards,
> > > Magne
> > >
> > >
> > > Date: Wed, 25 May 2005 10:55:39 -0500
> > > From: Shane_Cessna@xxxxxxx Add To Address Book
> > > Subject: RE: Jakarta POI HSSF question...
> > > To: Java Programming on and around the iSeries / AS400
> > > <java400-l@xxxxxxxxxxxx>
> > >
> > >
> > >
> > > Michael,
> > >
> > > Where can I find this CLASSPATH parameter?...
> > >
> > > Shane Cessna
> > > iSeries Programmer
> > > iSeries WAS Administrator
> > > North American Lighting, Inc.
> > > (618) 662-4483 x2776
> > > shane_cessna@xxxxxxx
>
> --
> 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.
>
>
>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.
