|
midrange.com
Gary,
Here's what WRKUSRJOB holds:
Work with User Jobs NAL820
05/26/05
13:51:54
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect
Opt Job User Type -----Status----- Function
QPADEV0037 SCESSNA INTER ACTIVE CMD-WRKUSRJOB
Bottom
Parameters or command
===>
F3=Exit F4=Prompt F5=Refresh F9=Retrieve F11=Display schedule
data
F12=Cancel F17=Top F18=Bottom F21=Select assistance level
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:50 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...
Hmmm. I'm looking this up. In the meantime, can you please do a
WRKUSRJOB
and see if there is a job starting with a Q under your user name that
might
have spool files with the stack trace?
Thanks,
Gary
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Shane_Cessna@xxxxxxx
> Sent: Thursday, May 26, 2005 11:33 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Jakarta POI HSSF question...
>
> 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.
> >
> >
> >
>
> --
> 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-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.
