Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Execute a stored procedure before rendering?
Migrateduser
I'm attempting to execute a stored procedure in my initialize script. I can't seem to get it to fire. When I look in my log it seems to get past the stored procedure just fine but it doesn't execute it. Any ideas? Here's the current code I have in my initialize script:
importPackage(Packages.com.ibm.tivoli.maximo.report.script);
mxReportScriptContext = MXReportScriptContext.initialize(reportContext);
mxReportScriptContext.setDefaultLogLevel("DEBUG");
mxReportScriptContext.setDefaultLogFile("c:/Temp/myreport.log");
scriptLogger = mxReportScriptContext.getReportScriptLogger();
storedprocDataSet = MXReportDataSetProvider.create("maximoDataSource", "storedprocDataSet");
storedprocDataSet.open();
scriptLogger.debug(">>>>>>>>>>>>>>>BEFORE INITIALIZE<<<<<<<<<<<<<<<");
var mysql = new String();
mysql = "call lirr_rpt_es_brg_ins_proc('" + params["wonum"] + "', 'APPR')";
scriptLogger.debug(mysql);
storedprocDataSet.setQuery(mysql);
scriptLogger.debug(">>>>>>>>>>>>>>>AFTER<<<<<<<<<<<<<<<");
storedprocDataset.close();
Find more posts tagged with
Comments
There are no comments yet