TechTip: Excel Flies Higher with JExcelApi

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
Please enable the Java console JDEBUG(*YES)and run the command again.

[buffcessna]

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
Hey all, I'm experiencing an error when I try to run this command... I'm passing in the sql statement from an RPG program...basically, I'm letting the user select which file they want to download and which months data they want...so I'm building my sql statment in my RPG program and passing a CL the statement... When the user runs this command, they get the following error in their job log: 700 - SQL2JXL SQLSTMT('select usgdated, usgprt#, usgmach, usgamt, usgauom, usguser from caspusg where usgdated between ''2004-09-01'' and ''2004-09-30'' order by usgmach') TOXLS('/excel/caspusg.xls') SHEETNAME('Paint Usage') COLHDRS(*LABEL) TITLE('Paint Usage') TITLEALIGN(*CENTER) 4500 - CALL PGM(SQL2JXLR) /* The CALL command contains parameters */ 9200 - RUNJVA CLASS('SQL2JXL') PARM(X'6185A783859361E2D8D3C9C4F1F2F8F4F1F94B8481A 300' '/excel/caspusg.xls' ' ' 'Paint Usage' 'L' 'Paint Usage' '-1' 'C' 'Y' 'Y' 'N' 'N' 'Y' 'N' 'SYS' 'N' 'NATIVE' 'LOCALHOST' ' ' ' ' 'N') CLASSPATH('/QIBM/ProdData/OS400/jt400/lib/jt400.jar:/excel:/excel/jxl.ja r') OPTION(*NONE) OUTPUT(*NONE) Java program completed with exit code 1 Function check. JVA0122 unmonitored by SQL2JXLC at statement 0000009200, instruction X'0000'. 12200 - SNDPGMMSG MSGID(CPF9898) MSGF(QCPFMSG) MSGDTA('Error running SQL2JXL') MSGTYPE(*ESCAPE) Error running SQL2JXL. Function check. CPF9898 unmonitored by CASQAQCC at statement 700, instruction X'001A'. CPF9898 received by CASQAQCC at 700. (C D I R) CPF9898 received by CASQAQCC at 700. (C D I R) Is there some kind of special authority a user needs in order to run this command? I'm posting my CL program. Shane

---

Code

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
There is a new PTF available to solve the problem of returning correct COLHDG with native driver. These are the instructions from Michael Swenson of IBM: ====================== The test PTF, SI16233, is available for this problem. Prior to ordering the PTF there are a couple of things to consider: - TEST PTFs should not be permanently applied in the event there is a problem discovered with the PTF. - Prior to ordering this PTF, you should order and install the latest available superseded PTF(s): SI14670 Installing the superseded PTF(s) is required to ensure the PTF can be properly removed (if needed) and to prevent the PTF from being permanently applied by the system due to requisite PTF processing. - Make sure the to review the cover letters for all PTFs delivered (see the DSPPTF or DSPPTFCVR command) ===========

[buffcessna]

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
We IPLd our iSeries and it works now...that was weird... Shane

[buffcessna]

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
I already gave authority to *PUBLIC to use this...and I'm still getting the error message...I'm posting the authority below... Shane

---

Code

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
Maybe you should give the authorithy to the ifs folder /excel. You can do it with wrklnk or with OpNav.

[buffcessna]

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
To run the SQL2JXL command... I'm pasting the code from the CL below. When a user other than myself tries to run it, it comes up with the following error: CPF9898 Escape 40 09/24/04 11:00:14.100576 SQL2JXLR QGPL *STMT SQL2JXLC QGPL *STMT From module . . . . . . . . : SQL2JXLR From procedure . . . . . . : SNDPGMMSG Statement . . . . . . . . . : 435 To module . . . . . . . . . : SQL2JXLC To procedure . . . . . . . : SQL2JXLC Statement . . . . . . . . . : 4500 Message . . . . : Error CrtSQLstmt : open() failed. 3401 : Permission denied.. Cause . . . . . : This message is used by application programs as a general escape message. Shane

---

Code

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
. . to run what ? Where do you get the error ?

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
I'm trying to let users run this in a batch job via a CL program...In the job log it denies them due to authority. What type of special authority do they need in order to run this? Shane

[MCWebsite.Staff]

TechTip: Excel Flies Higher with JExcelApi

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
** This thread discusses the Content article: TechTip: Excel Flies Higher with JExcelApi **
0

Re:TechTip: Excel Flies Higher with JExcelApi

Hi thanks for these great utilities. Im using SQL2JXL and am having a couple of problems. I'm sure i'm just doing something wrong. 1) When i use a template XLS, it resizes my column widths. Is there a way to stop this? and 2) Again when using a template. It inserts a couple of blank lines between the template and the sql data retrieved. Can this be stopped? Thanks for your help!

TechTip: Excel Flies Higher with JExcelApi

I've seen a couple of messages about "authority problems" but I've yet to see any solutions. The error I see is: MCH1001 - Attempt to use permanent system object CDRCVRT without authority. CDRCVRT is an IBM supplied *PGM object in QSYS2. It has *PUBLIC set to *EXCLUDE. I'm assuming that this is teh program for the Convert a Graphic Character String (CDRCVRT, QTQCVRT) API. Thanks

TechTip: Excel Flies Higher with JExcelApi

We are using SQL2JXL/SQL2POI on our V5R2 for more than a year and are very happy with the tool. Recently we have installed SQL2JXL/SQL2POI on our V5R1 machine, but are getting the error "Function check. JVA0122 unmonitored by SQL2JXLC at statement 0000009200".(The output of the Jave Shell Display is put below) It looks to me that Java is missing something, but I don't know what. The following Licensed programs are installed: 5722JC1 *BASE Toolbox for Java 5722JV1 *BASE Developer Kit for Java 5722JV1 3 Java Developer Kit 1.2 5722JV1 4 Java Developer Kit 1.1.8 5722JV1 5 Java Developer Kit 1.3 Any ideas ?

---

Code

[david.brown@kalon.co.uk]

TechTip: Excel Flies Higher with JExcelApi

I had the same problem but with the help of our friends at IBM they pointed out that you will get this error if your Jobs CCSID is 65535. I changed my job to 37 (CHGJOB CCSID(37)) and it worked fine. Depending on your country and language you may need to use a different CCSID. Regards David

TechTip: Excel Flies Higher with JExcelApi

The mask should be "#,##0.00". Excel formats numbers according to the windows settings.