Hyperlink in ms excel – use of JCL PARM, SYSIN

How to provide hyperlink in Microsoft Excel:

Function =HYPERLINK(“url_link”, “display_name”) is used in MS Excel for creating hyperlinks.

If we have created all the links using Microsoft word — it replaces simple quotes with smart quotes — which excel doesn’t take for hyperlink function. We have to replace all smart-quotes (“”) with simple quotes (“”).

Mainframe Tips:

If we are passing data from JCL PARM=”data” then we have to take care in linkage section for removing the wrapper using picture s9(04) comp. and then the catch the real data.

The data we pass through SYSIN can be read by ACCEPT statements in COBOL

SPF PC (ISPF for PC) graphical version

found out the makers of SPF PC. they have developed graphic version of command line editor SPF for using on windows PC.

SPF/SE 6.0 for Windows

A character mode 3270 style interface with Option Menus as the primary method of access. A primary command field is provided in all Option Menus, Dialogs, File List and Edit. GUI elements such as buttons, combo boxes, and scroll bars are also supported. A Windows style main menu bar is optional.

*For details on features and commands, download the free demo. After install see HELP, item QUICK REF.

https://www.commandtechnology.com/main.asp?pg=products

this is useful for practicing the ISPF commands on a PC when mainframe connectivity is not available.