[CLOSED] Need to execute a MVS Procedure and Call Excel Template
Hello,
I have some webfocus fexs that have to run on the mvs mainframe environment. These procedures are executed by report caster. Is there a way to position a excel template so the mvs procedure can find it from report caster.
Thanks
Dan MoyerThis message has been edited. Last edited by: moyer1dl,
IBM Main Frame: MVS, FIX, VSAM
Windows SQL
WF 7.7
December 09, 2008, 12:17 PM
Kerry
Hi Dan,
Info from a case: Bursting an Excel Template document in ReportCaster is supported starting in ReportCaster 713.
If you still have questions, please contact Information Builders' Customer Support Services and open a case.
Hope this helps.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
December 09, 2008, 02:47 PM
moyer1dl
Thanks
IBM Main Frame: MVS, FIX, VSAM
Windows SQL
WF 7.7
December 10, 2008, 03:30 AM
<JG>
Dan you do not mention that you want to burst the reports just that you want to use a template.
Excel templates are supported in your version 7.1.1
The template files must reside in a PDS with a RECFM VB and LRECL 512.
You will need to allocate the PDS to a ddname of MHT
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'MHT' SHEETNUMBER 1 ON TABLE SET STYLE * UNITS=IN,
Then I get an Error
Task error: UNABLE TO FIND DDNAME MHT
No report to distribute.
Any Help
Thanks
Dan
IBM Main Frame: MVS, FIX, VSAM
Windows SQL
WF 7.7
December 11, 2008, 05:52 PM
R Veit
Did you upload your Excel template to PIA.IA0033LF.XLS.MHT? It's been a while since I've done this, but here is the little bit of documentation I put together:
To create the template, open EXCEL. Insert a blank worksheet Put blank space in first cell on blank worksheet Rename sheets if you want Under Tools, click Macro – Record Name should be Auto_open Copy data from sheet2 to sheet1 Do formatting (bold, underline, cell shading, cell sizes, etc.) Stop Recording Delete the data from sheet1 Save as mht file (i.e. tempx.mht)
Upload mht file to your MVS PDS, PIA.IA0033LF.XLS.MHT, and name it what you saved your Excel file as (i.e. TEMPX).
In your fex, change MHT to TEMPX:
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'TEMPX' SHEETNUMBER 2
7.6.11 on Win 2003/IIS 6/Apache Tomcat 5.5 - MRE, ReportCaster Reporting Server z/OS 1.11, PDS Unified Excel, PDF, HTML
December 12, 2008, 08:21 AM
<JG>
Dan,
The template file should be a member of a PDS allocated to the DDNAME of MHT. It is not a sequential file.