Using DDBuilder
To Create a Data Dictionary for Use with |
To Modify a Data Dictionary for Use with |
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:
-
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.
-
Add tables, columns, and, optionally, indices, to the structure.
-
Save the data dictionary (see Saving a Data Dictionary).
-
Define each table and its attributes in the General Table property page (see Defining General Table Attributes ).
-
Define the attributes for each column in the table in the General Column property page (see Defining General Column Attributes).
-
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).
-
Define views for ODBC data dictionaries (see Defining Views ).
-
Save the data dictionary again.
-
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:
-
Proceed to one of the Opening an Existing Data Dictionary sections, as follows:
-
To open a data source that is defined in an SQL.INI file, use the Opening a Data Source dialog.
-
To open a data source that is not defined in an SQL.INI file, use the Opening a Configuration File dialog.
-
-
In the tree view, do any of the following to modify the data dictionary:
-
Add, insert, rename, copy, paste, and delete elements.
-
Redefine tables and their attributes in the General Table property page (see Defining General Table Attributes).
-
Redefine the attributes for each column in the table in the General Column property page (see Defining General Column Attributes).
-
Redefine indices for MKEYED, DIRECT, C-ISAM, or SORT tables (see Defining Indices).
-
Redefine views for ODBC data dictionaries (see Defining Views).
-
-
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:
-
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.
-
Add tables, columns, and, optionally, indices, to the structure.
-
Save the data dictionary (see Saving a Data Dictionary).
-
Define the data source rules in the General Rules property page (see Defining Rules).
-
Define the data source typedef in the Typedef property pages (see Defining Typedefs).
-
Define tables and attributes in the General Table property page (see Defining General Table Attributes).
-
Define the remaining table properties (see Defining Advanced Table Option).
-
Define the attributes for each table's column in the General Column property page (see Defining General Column Attributes).
-
Define the remaining column properties (see Defining Advanced Column Options).
-
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).
-
Save the data dictionary again.
-
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:
-
Proceed to one of the Opening an Existing Data Dictionary sections, as follows:
-
To open a data source that is defined in an SQL.INI file, use the Opening a Data Source dialog.
-
To open a data source that is not defined in an SQL.INI file, use the Opening a Configuration File dialog.
-
-
In the tree view, do any of the following to modify the data dictionary:
-
Add, insert, rename, copy, paste, and delete elements .
-
Redefine the data source rules in the General Rules property page (see Defining Rules).
-
Redefine the data source typedef in the Typedef property pages (see Defining Typedefs).
-
Redefine tables and attributes in the General Table property page (see Defining General Table Attributes).
-
Redefine the attributes for each column in the table in the General Column property page (see Defining General Column Attributes).
-
Redefine indices for MKEYED, DIRECT, C-ISAM, or SORT tables (see Defining Indices).
-
-
Save the data dictionary (see Saving a Data Dictionary ).