Importing Tables or Views from a VSAM Text File Import Specification - MVS-OS/390 or VSE
The FTP process copies the text file import specification off the host.
To import tables or views from a text file:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select VSAM text specification file in the Import Type list box.
3. Do one of the following:
If importing on MVS-OS/390, type the full sequential or partitioned data set name for the text file you created and stored on the host in the Enter a VSAM data set member text box.
If importing on VSE, type the fully qualified library.sublib.member.type name for the text file you created and stored on the host in the Enter a VSAM data set member text box.
4. Type the server name or IP address, a user name, and password in the corresponding text boxes on the Logon Information tab.
Port 6500 is listed in the TCPIP Port text box by default. Any change made to the port setting in this text box becomes a permanent change to the port setting of the imported database.
5. Select a Destination Database for the imported tables.
6. From the list of available tables or views, select each imported table or view and do the following:
For tables, click the Table Indexes tab in the CONNX Data Dictionary Manager window and click the Refresh Indexes button.
For views, click the Syntax check button located under the View SQL tab.
7. Save the CDD by clicking File -> Save.
Note:
If CONNX detects more than one record layout when importing, multiple data dictionary entries are created.