Performing a VSAM SCT DBD (Database Definition) Overlay Import - VSE
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. In addition, the comments contain the SCT mnemonic for each field, making it easy to locate a desired field by using the CONNX Find feature.
See
Importing from VSAM COBOL FD files (CICS) - VSE for information on how to authorize and verify FTP access.
1. Click the Import button in the CONNX CDD Windows Application window.
2. Select VSAM SCT COBOL FD files in the Import Type list box.
3. Type a fully qualified library.sublib.member.type SCT COBOL FD name in the Enter an SCT COBOL FD file name text box.
For example, type SCTLIB.SIS.ACAARC.C. The SIS files from the specified COBOL FD file are imported.
4. Click the OK button to import the SCT layouts.
The process may take a few minutes depending on the number of files imported.
5. When the process is complete, click Tools -> SCT DBD Overlay Import.
6. 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.
The SCT Focus DBD overlay files are defined as sequential files in VSAM space. Given an example VSAM user catalog name of CNXCAT1 and the default SCT installation prefixes, the fully qualified SCT Focus DBD overlay files are named as follows:
CNXCAT1.SCT.ADVS02.XDS004 | Alumni Development System |
CNXCAT1.SCT.FRVS03.XDS002 | Financial Records System |
CNXCAT1.SCT.HRVS04.XDS003 | Human Resource System |
CNXCAT1.SCT.NLVS02.XDS005 | Loan Management System |
CNXCAT1.SCT.SIVS01.XDS001 | Student Information System |
CNXCAT1.SCT.ZSVS01.XDS000 | Z Support Software System |
7. Select the Specify an alternate location of the DBD file check box and then type the location in the text box below.
For example, to define the CNXCAT1 user catalog to the TCP/IP for VSE job as a VSAM catalog, input the following command:
DEFINE FILE,PUBLIC='CNXCAT1',DLBL=CNXCAT1,TYPE=VSAMCAT,READONLY=YES
The entry for CNXCAT1 can be permanently added to the VSE TCP/IP configuration by updating the initialization JCL member (IPINIT00) with the control record syntax above, submitting the batch job to the VSE POWER batch queue, and stopping and restarting TCP/IP. The CNXCAT1 entry can be temporarily defined to the currently executing version of TCP/IP via VSE console commands, for example:
msg f7
AR 0015 1I40I READY
F7-0087 IPN300I Enter TCP/IP Command
87 DEFINE FILE,PUBLIC='CNXCAT1',DLBL=CNXCAT1,TYPE=VSAMCAT,READONLY=YES
8. Start a Windows command prompt and enter the dir command to verify the entries that are currently defined for FTP access to the VSE TCP/IP job.
9. Select the VSAM database to overlay in the Database to Overlay list box.
10. Click the OK button.
The conversion to FOCUS field names may take a few minutes, depending on the number of files imported.
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 CONNX inserted comments containing a mnemonic code for each file and field and changed the field names.