Importing Tables or Views from a VSAM Text File Import Specification
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. 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.
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.