ddbicon.pngDDBuilder: Creating a New Data Dictionary (Superseded)

DDBuilder has been superseded by the BASIS DBMS Data Dictionary module accessible from the BASIS IDE or the Enterprise Manager. Recommended for usage with ODBC/JDBC access to PRO/5, Visual PRO/5, BBj application data. DDBuilder is no longer included in the BBj download package as of version 12.0 but can be downloaded with Visual PRO/5.

Description

Creating a new data dictionary involves creating a data source and making data files.

Creating a Data Source

Creating a new data source involves designating directories for the dictionary and data storage files, creating a configuration file, and, optionally, naming the data dictionary. To create a data source, do the following:

  1. On the File menu, select New to display the Create New Data Source dialog:

    opends.png

  2. Move to the directory where the configuration file and DATA and DICTIONARY subdirectories should be installed.

  3. Enter a name for the configuration file (the standard is config.tpm) into the File name field.

  4. Create the DATA and DICTIONARY subdirectories by clicking the standard Windows Create New Folder button, which is the third button from the right in the upper right-hand corner of the dialog.

  5. Enter the path to the DATA and DICTIONARY directories in the appropriate fields. If the data source will be accessed from a network, enter the user ID in the USERID field.

  6. Enter a data source name into the Data Source Name field. This name will appear in the SQL.INI file.

  7. Once the path and data source information has been entered, navigate to the base directory and click Create. DDBuilder will then create the configuration file and the base files in the DICTIONARY directory. The tree view then appears, displaying the base Tables, typedef, Rules, and Views entries. Add tables to the data source.

Making Data Files

Making data files involves creating empty PRO/5 files for use in applications after table, column, and index information has been defined.

The Make command creates empty data files. Do not use this command on preexisting data files, except to remove all file records.

To make data files, do the following:

  1. In the tree view, click on the icon of a table to select it.

  2. On the Edit menu, select Make to create the data files in the path specified in the General Table properties page's Path field.

  3. Save the data dictionary (see Saving a Data Dictionary ).