હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

ઓક્ટોબર 18, 2007

Hyperlink in ms excel – use of JCL PARM, SYSIN

Filed under: learning,mainframe — Himanshubhai Mistry @ 8:26 પી એમ(pm)
Tags: , , , , ,

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
  • Blog at WordPress.com.