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

    સપ્ટેમ્બર 28, 2007

    SPF PC (ISPF for PC) graphical version

    Filed under: Uncategorized — Himanshubhai Mistry @ 1:54 પી એમ(pm)
    Tags: , , , ,

    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.

    Create a free website or blog at WordPress.com.