To import existing formatted DDL (Data Definition Language) table definitions

  1. Click the Import button in the CONNX Data Dictionary Manager window.

  2. The Import CDD dialog box appears. Select RMS DIBOL files in the Import Type list box.

  3. Type a dictionary path for the DDL record definition in the Enter a DDL file name text box, for example, DKA600:[MYDIR]CUSTOMER.DDL

    Note:     Wildcard characters may be used in the dictionary path.

    Note:     If CONNX detects more than one record layout when importing, multiple data dictionary entries are created.

    Note:     Multiple files can be specified in the text box by separating each file name with a comma. The allowable limit is 255 characters.

  4. You can also use the Browse button below the text box to locate files to import. If you do not need to use the Browse button, proceed to Step 6.

  5. Click the Browse button. If you are not connected to a VMS server, the CONNX Database Login dialog box appears.

    VMSBasic_10.gif
     

  1. Type the server name or IP address, a user name, and password in the corresponding text boxes.

  2. Port 6500 is listed in the TCPIP Port text box by default.

  3. Click the OK button. The Browse dialog box appears.

  4. Select the file(s) in the Browse dialog box, and then click the OK button to return to the Import CDD dialog box.

    Browse_01.gif

  1. Enter the following information in the Import CDD dialog box:

  1. Type the server name or IP address, a user name, and password in the corresponding text boxes on the Logon Information tab.

  2. Port 6500 is listed in the TCP/IP 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. See "To edit the OpenVMS Site-Specific Startup Command Procedure" in the CONNX Installation Guide for information on changing the port setting on the server.

  3. Select the destination database from the Destination Database list box. See Adding a database connection for more information.

  1. Click the OK button.

    VMSBasic_07.gif
     

  2. Formatted DDL import specifications do not contain the RMS data file name, therefore, the RMS data file must be specified manually or by using the Browse button on the Table Properties tab in the CONNX Data Dictionary Manager window after the import is complete. See To use the CONNX Browse button. Because the RMS file name is unknown, the indexes must also be refreshed. See To view an index for information on refreshing indexes.

    From the list of available tables, select each table to import and follow these steps:

  1. Click the Table Properties tab in the CONNX Data Dictionary Manager window.

  2. Type the data file name and path in the RMS file name text box.

  3. Click the Table Indexes tab in the CONNX Data Dictionary Manager window, and then click the Refresh Indexes button. A message saying the indexes are successfully refreshed appears.

  4. Save the CDD by clicking Save on the File menu.