Importing an Oracle RDB Table
When importing Oracle Rdb database tables, users can access and manipulate Oracle Rdb data with all of the data that CONNX can access through a single driver.
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Rdb database from the Import Type list box.
3. Type the Rdb database name in the Enter the Full RDB Database Name text box.
You can override the name of the RDB database by entering a connection string parameter where, for example, RDBNAME = databasename.
4. Specify the full VMS path for the database. The path may include logicals.
Select the Include System Tables check box if you want to import system table definitions into the CDD.
Select the Get Statistics check box if you want to identify the table sizes.
5. Type a server location, user name, and password under Logon Information.
a. Server - Name of the OpenVMS system running CONNX for Rdb.
b. UserName: - OpenVMS user name used to log in to the account where the database resides.
c. Password: - OpenVMS 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 Treat RDB List Cursors as Text Fields instead of Binary Fields check box if your RDB data contains RDB list cursors that contain text data.
Rdb list cursors are also known as document fields. Selecting this option would depend on the front-end application in use.
7. Click the OK button.
The CONNX Import Table Selection dialog box appears with a list of available table names.
8. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
9. Click the OK button to import the selected tables into CONNX.
The Oracle RDB database tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.