Importing Codasyl DBMS Tables
Important:
If you intend to import subschemas, see Including Subschemas with Codasyl DBMS Table Imports.
When importing DBMS database tables, users can access and transfer DBMS data with all of the data that CONNX can access through a single driver.
To import a Codasyl DBMS table:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select DBMS Codasyl database from the Import Type list box.
3. Type the DBMS database name in the Enter the full DBMS database name text box.
4. Specify the full OpenVMS path for the database. Include the .roo file extension, for example, DKA600:[MYDIR]PRODUCTS.ROO
If you are importing subschemas, the OpenVMS path for the database can include the name of the subschema, for example, DKA600:[MYDIR]PRODUCTS.ROO SUBSCHEMA. The path may include VMS logicals.
5. Type a server location, user name, and password under Logon Information.
a. Server: Name of the VMS system running CONNX for DBMS.
b. UserName: VMS user name used to log in to the account where the database resides.
c. Password: VMS password used to log in to the account where the database resides.
d. TCP/IP Port: Set to 6500 by default but can be changed for any current transaction.
6. Click the OK button.
7. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
8. Click the OK button to import the selected tables into CONNX.
The DBMS database tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.
Note:
If CONNX detects more than one record layout when importing, multiple data dictionary entries are created.