To perform a VSAM SCT DBD (Database Definition) Overlay Import - MVS-OS/390

You can overlay the imported COBOL FD field names in your CONNX CDD with the corresponding FOCUS™ DBD names. You can also use the CONNX SCT DBD Overlay Import feature to add comments that correlate to the help screens in your application. Additionally, the comments contain the SCT mnemonic for each field, making it easy to locate a desired field by using the CONNX Find feature.  

See To import from VSAM COBOL FD (File Definition) files (CICS) - MVS-OS/390  for information on how to authorize and verify FTP access.

  1. Click the Import button in the CONNX CDD Windows Application window.

  2. The Import CDD dialog box appears. Select VSAM SCT COBOL FD files in the Import Type list box.

  3. Type an SCT COBOL FD partitioned data set and member name in the Enter an SCT COBOL FD data set member text box. To import the SCT AAFILE, for example, enter:    

SCT.SISBASE.SOURCE(ACAARC)

  1. The SIS files from the specified COBOL FD files are imported.

    VSAMIMP_22.jpg
     

  2. Click the OK button to import the SCT layouts.

  3. The SCT file layouts are imported. The process may take a few minutes depending on the number of files imported.

    VSAMIMP_37.jpg

  4. On the Tools menu in the CONNX Data Dictionary Manager window, select SCT DBD Overlay Import.

  5. The SCT DBD Overlay Import dialog box appears. Select the Import Comments Only check box to add only the DBD comments currently in your CDD. Importing comments only adds the mnemonic file and file identifier and any comments existing for each field in the DBD file.

    VSAMIMP_14.jpg
     

  6. Select the Specify an alternate location of the DBD file check box and then type the location in the text box below.

  7. It is not necessary to have the "DBD".DAT files in order to import from an OS/390 system. Given the default SCT installation prefixes, the SCT Focus DBD sequential overlay files are:

SCT.ADSBAS.XEDS004

Alumni Development System

SCT.FRSBASE.XDS002

Financial Records System

SCT.HRSBASE.XDS003

Human Resource System

SCT.LMSBASE.XDS005

Loan Management System

SCT.SISBASE.XDS001

Student Information System

SCT.ZSSBASE.XDS000

Z Support Software System

  1. Select the VSAM database to overlay in the Database to Overlay list box.

  2. Click the OK button. Note that SIS modules are used for this example.

  3. The conversion to FOCUS field names may take a few minutes, depending on the number of files imported.

  4. Once the files are converted, select a table from the list in the upper pane. The COBOL field names in the selected modules are converted to FOCUS field names. Note that comments containing a mnemonic code for each file and field are inserted, and that the field names have changed.

    ch1107.jpg

Note: Partial (for example AC*) or complete (*) wildcard characters may be used in place of a file name during import.