November 09, 2006, 04:47 PM
loomisFORMAT EXL2K on the mainframe
I am trying to write different reports to different sheets of the same Excel workbook. The technique I attempted was as follows:
TSO ALLOC DD(TESTC) DA(TESTC)SHR REU
TABLE FILE DEBIT
PRINT AFO
IF READLIMIT IS 10
ON TABLE HOLD AS TESTC FORMAT EXL2K OPEN
END
TABLE FILE DEBIT
PRINT CLMNUM
IF READLIMIT IS 10
ON TABLE HOLD AS TESTC FORMAT EXL2K CLOSE
END
I get the following message on the mainframe:
ERROR AT OR NEAR LINE 6 IN PROCEDURE TEST2 FOCEXEC
(FOC002) A WORD IS NOT RECOGNIZED: OPEN
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
ERROR AT OR NEAR LINE 11 IN PROCEDURE TEST2 FOCEXEC
(FOC002) A WORD IS NOT RECOGNIZED: CLOSE
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
As per tech support, it seems the mainframe version 7.3 does not support the OPEN and CLOSE feature. I also tried PCHOLD with no success. I do not have a version of Webfocus or EDA only FOCUS on the mainframe.
I have seen some posts where various reports are written to the same ddname format EXL2K with DISP=MOD and through manipulation of the HTML the various reports appeared on the same worksheet separated by a space.
Can a similar thing be done to put these reports on different worksheets by only employing mainframe code?
November 13, 2006, 09:44 AM
KerryHi loomis,
Here is what I have from internal resources: We do not support multiple worksheets in Mainframe FOCUS and is expected to be available in the 7.6.0 release.
Hope this helps.
Cheers,
Kerry
November 13, 2006, 10:47 AM
Noreen ReddenSorry, not with the current 7.3 version of FOCUS. This is a new feature added as part of the 7.6 release of FOCUS. In the current version of FOCUS, you are correct, there is only the option to create a single worksheet .
Noreen Redden
Product Management
FOCUS Division