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

October 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
  • 1 Comment »

    1. very interesting. i’m adding in RSS Reader

      Comment by Melina — December 20, 2007 @ 10:03 pm | Reply


    RSS feed for comments on this post. TrackBack URI

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    Blog at WordPress.com.

    %d bloggers like this: