હિમાંશુ પરભુભાઇ મિસ્ત્રી | 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
  • Advertisements

    1 ટીકા »

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

      ટિપ્પણી by Melina — ડિસેમ્બર 20, 2007 @ 10:03 પી એમ(pm) | જવાબ આપો


    RSS feed for comments on this post. TrackBack URI

    પ્રતિસાદ આપો

    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 / બદલો )

    Twitter picture

    You are commenting using your Twitter account. Log Out / બદલો )

    Facebook photo

    You are commenting using your Facebook account. Log Out / બદલો )

    Google+ photo

    You are commenting using your Google+ account. Log Out / બદલો )

    Connecting to %s

    Blog at WordPress.com.

    %d bloggers like this: