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