TechTip: Excel Flies Higher with JExcelApi

[MCWebsite.Staff]

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

[R.Daugherty]

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
I have a question. Why do you MONMSG CPF0000 in your CL? rd

[R.Daugherty]

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
The question was supposed to follow Shane's posting of CL code which has a MONMSG MSG(CPF0000) in it. I was asking why, but if everything is working just disregard. rd

[dacust]

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
Many people put a MONMSG CPF0000 to catch any extraneous errors from crashing a CL. The proper way would be to have a standard error routine to handle the situation, like MONMSG MSGID(CPF0000 CPA0000) EXEC(GOTO CMDLBL(ERROR)). To see examples of this, do a search on this site for STANDARD ERROR HANDLING. On the search results page look over to the right in the block "Results From the Forums". Funny thing is, the first post shown when I did that was one of mine. -dan

[buffcessna]

** This thread discusses the article: TechTip: Excel Flies Higher with JExcelApi **
OK, that's cool...I changed the CL to use the SQL2XLS and it works fine...So, I guess I'll just use that one...Thanx for all the input guys... Shane

[MauroRomeo]

After migration in a new As400 V5R3 SQL2POI and SQL2JXL don't work Every request end in error. This is log: SQL2JXL SQLSTMT('select * from mylib/clienti') TOXLS('/mydir/clienti.xls') Programma Java completato con codice di uscita 1 Errore di funzione. JVA0122 non monitorato da SQL2JXLC all'istruzione ad alto livello 0000000092, istruzione '0000'. Error running SQL2JXL. As i can do. Thank you Mauro Romeo romeo@photorec.it

[gcostagliola@tin.it]

run the cmd with JDEBUG(*YES) to have more details on the error.

[gcostagliola@tin.it]

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

[david.brown@kalon.co.uk]

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

[Guest.Visitor]

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