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
** 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
Comment