Adding a Database Connection
You can add a new or additional database connection to an already existing RMS, C-ISAM, and VSAM databases in the CONNX Data Dictionary Manager window. Each database listed in the CONNX Data Dictionary Manager window can be associated with a different server. This feature can be used for organizational purposes, or for importing tables from the same database in instances where the databases are located on two different servers and the CONNX Listener is listening on two different ports.
You should create the database connection before attempting to import an additional database from your server in order to prevent accidentally erasing files that may be duplicates of others already existing in another database container in the CONNX Data Dictionary Manager window.
To add a database connection:
1. Click Tools -> Add Database Connection.
2. Enter the new name of the database from which you will be importing files.
3. Select a database type (either RMS, C-ISAM, or VSAM) from the list box.
4. Enter the server name and click the OK button.
5. Log on to your system database by entering the server name, a user name and password, and the TCP/IP port.
If you are using Pathworks, the TCP/IP port text box does not appear.
The new database container appears in the upper pane of the CONNX Data Dictionary Manager window.
6. Click the Import button to import files into the new database.
7. Enter the appropriate information for your database type.
See the section on RMS imports ("CONNX for DataFlex, RMS, and DBMS Databases") for more information.
8. Select the desired destination database from the Destination Database list box.
The file will be added to the new container in the CONNX Data Dictionary Manager window.