ddbicon.pngUsing DDBuilder


To Create a Data Dictionary for Use with

To Modify a Data Dictionary for Use with

PRO/5, the BASIS ODBC Driver, and BBxPROGRESSION/4

PRO5, the BASIS ODBC Driver, and BBx PROGRESSION/4

TAOS

TAOS

Creating PRO/5, ODBC Driver, and BBxPROGRESSION/4 Data Dictionaries

To create a new data dictionary for use with PRO/5, the BASIS ODBC Driver, or BBx PROGRESSION/4, do the following:

  1. Follow the Creating a New Data Dictionary procedures to establish the data and dictionary files location, create data directories and paths, establish a configuration file, and, optionally, create a SQL.INI file.

  2. Add tables, columns, and, optionally, indices, to the structure.

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

  4. Define each table and its attributes in the General Table property page (see Defining General Table Attributes ).

  5. Define the attributes for each column in the table in the General Column property page (see Defining General Column Attributes).

  6. If an MKEYED, DIRECT, C-ISAM, or SORT table has been defined, then define at least one index in the General Index property page (see Defining the Index Structure).

  7. Define views for ODBC data dictionaries (see Defining Views ).

  8. Save the data dictionary again.

  9. Make the data files (see Making Data Files). This creates the data files described by the dictionary definition.

Modifying PRO/5, ODBC Driver, and BBxPROGRESSION/4 Data Dictionaries

To modify an existing data dictionary for use with PRO/5, BBx PROGRESSION/4, or the BASIS ODBC Driver, do the following:

  1. Proceed to one of the Opening an Existing Data Dictionary sections, as follows:

  2. In the tree view, do any of the following to modify the data dictionary:

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

Creating Data Dictionaries for Use with TAOS

To create a new data dictionary for use with TAOS, do the following:

  1. Follow the Creating a New Data Dictionary procedures to establish the data and dictionary files location, create data directories and paths, establish a configuration file, and, optionally, create a SQL.INI file. This creates the data dictionary files.

  2. Add tables, columns, and, optionally, indices, to the structure.

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

  4. Define the data source rules in the General Rules property page (see Defining Rules).

  5. Define the data source typedef in the Typedef property pages (see Defining Typedefs).

  6. Define tables and attributes in the General Table property page (see Defining General Table Attributes).

  7. Define the remaining table properties (see Defining Advanced Table Option).

  8. Define the attributes for each table's column in the General Column property page (see Defining General Column Attributes).

  9. Define the remaining column properties (see Defining Advanced Column Options).

  10. If an MKEYED, DIRECT, C-ISAM, or SORT table has been defined, then define at least one index in the General Index property page (see Defining Indices).

  11. Save the data dictionary again.

  12. Make the data files (see Making Data Files). This creates the data files described by the dictionary definition.

Modifying Data Dictionaries for Use with TAOS

To modify an existing data dictionary for use with TAOS, do the following:

  1. Proceed to one of the Opening an Existing Data Dictionary sections, as follows:

  2. In the tree view, do any of the following to modify the data dictionary:

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