Cris,
The workstation agent can do that for you. I use it to automatically open excel
on my pc whenever my sasjob has created my excel with ods.
Little sas example that creates an ASCII excel (with TRANTAB=ASCII) on z/OS.
(RECORD_SEPARATOR=NONE and RUN; are neccesary to make it work):
ODS TAGSETS.EXCELXP FILE=XML RECORD_SEPARATOR=NONE TRANTAB=ASCII
OPTIONS(FROZEN_HEADERS='YES'
EMBEDDED_TITLES='YES'
SHEET_NAME='nice sheet name');
PROC PRINT DATA=something NOOBS;
RUN;
ODS TAGSETS.EXCELXP CLOSE;
For details on the workstation agent look at
http://gsf-soft.com/Documents/ISPF-CS.shtml
I use the following for the example above, where the excel is in USERID.EXCEL
dataset:
SET IPADDR = 10.x.x.x (my pc ip address)
WRITE CONNECTING TO WORKSTATION &IPADDR
ISPEXEC WSCON IP(IPADDR) NOGUIDSP
SET HVAR = EXCEL (dataset USERID.EXCEL)
SET WVAR = C:\TEMP\EXCEL.XLS (where to place it on my pc)
WRITE SENDING FILE &SYSUID.&HVAR TO &WVAR
ISPEXEC FILEXFER HOST(HVAR) WS(WVAR) TO(WS) BINARY NOSTATS (I use binary
instead of text since TRANTAB=ASCII already made it ascii)
WRITE OPENING FILE &WVAR WITH EXCEL
ISPEXEC SELECT WSCMD(CMD /C START EXCEL &WVAR) MODAL (the trick to open
excel)
Hope it makes sense...
Erik.
-----Oorspronkelijk bericht-----
Van: IBM Mainframe Discussion List [mailto:[email protected]] Namens Cris
Hernandez #9
Verzonden: dinsdag 8 februari 2011 23:08
Aan: [email protected]
Onderwerp: Re: Data Masking - 3270 Sceens
Written 3270 emulators?
Any emulators out there that not only do the data xfer between mainframe and
pc, but also kick off the pc software required to open the file?
When creating SAS graphs on MVS, I found all the stepx I had to take to view
them on the pc quite annoying.
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
