To import from VSAM COBOL FD files - Started Task

  1. Click the Import button in the CONNX Data Dictionary Manager window.

  2. The Import CDD dialog box appears.

    VSAMIMP_44.jpg
     

  3. Select VSAM COBOL FD files in the Import Type list box.

  4. In the Enter a COBOL FD data set member text box, enter CONNX.VVRR.STASK.COPYBOOK.(CUSTOMER).

  5. Specify the fully qualified PDS (partitioned data set) and member name for the COBOL FD, for example, CONNX.VVRR.STASK.COPYBOOK(CUSTOMER). A COBOL FD specification does not contain the corresponding File Control Table (FCT) name or Started Task DD (Data Definition) name; therefore, it must be specified on the Table Properties tab in the CONNX Data Dictionary Manager window when the data is returned.

  1. All of the record layouts in the specified file are imported.

  2. No additional logon information is required.

  1. In the Server text box, enter the symbolic or dotted numeric TCP/IP address of the target host, and then enter your TSO user name and password. Enter a TCP/IP port number, and then click the OK button.

  2. Type a user name in the User Name text box.

  3. The user ID must be authorized for FTP access to the target host, and must contain a RACF OMVS segment. For example, the default user ID USER can be modified via RACF commands to permit FTP access by adding an OMVS segment:  

USER=USER  NAME=USER
OMVS INFORMATION  
________
  
UID= 0000000000  
CPUTIMEMAX= NONE
ASSIZEMAX= NONE   
FILEPROCMAX= NONE
PROCUSERMAX= NONE
THREADSMAX= NONE  
MMAPAREAMAX= NONE
  1. The userid used for CONNX CDD imports need not be authorized for TSO access, as long as it has read authority to the target COBOL copybook partitioned data sets. By default, the CONNX COBOL copybooks reside in CONNX.VVRR.STASK.COPYBOOK.(CUSTOMER).

  2. Type a password in the Password text box.

  3. The TCPIP port number is set to 6500 by default, but can be configured via the CONNX NX01 transaction. See "To convert the CONNX port number to the default" in the CONNX Installation Guide for configuration information.

  4. Select a Destination Database for the imported tables. See Adding a Database Connection for more information.

  5. Select each file to import and follow these steps:

  1. Click the Table Properties tab in the CONNX Data Dictionary Manager window.

  2. Type the name for the file in the File Name text box. For example, the short file name for the CONNX VSAM KSDS sample customer file is CNXCSTK.

    Image3.png
     

  3. Tab out of the File Name text box to display the CONNX Database Logon dialog box. Click the OK button.

  4. Click the Table Indexes tab to display the key information for the imported VSAM file.  

  5. If the Table Index information list box is empty, click the Refresh Indexes button. If the list box remains empty, no indexes are defined on the imported VSAM file.

    Image4.png
     

  6. Repeat steps a) through e) for each file for which there is imported metadata.

  7. Save the CDD by selecting the File menu and then clicking Save.

  1. For the CONNX sample files using the CONNX.VVRR.STASK. COPYBOOK prefix, select from this list of member names and file names:
     

CONNX.VVRR.STASK.COPYBOOK Member Name

File Name

CUSTOMER

CNXCSTK

CUSTOMRE

CNXCSTE

CUSTOMRR

CNXCSTR

EQUIPMNE

CNXEQE

EQUIPMNR

CNXEQR

EQUIPMNT

CNXEQK

ORDER

CNXORK

ORDERE             

CNXORE

ORDERR

CNXORR

PRODGRP

CNXPGK

PRODGRPE

CNXPGE

PRODGRPR

CNXPGR

PRODUCT

CNXPRDK

PRODUCTE

CNXPRDE

PRODUCTR

CNXPRDR

 

Note: For your site, specify the COBOL copybook PDS/member and the corresponding file name to import test or production metadata.