ddbicon.pngWhat is DDBuilder? (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.

DDBuilder is a utility that can quickly and easily define and create new BASIS data dictionaries, modify existing data dictionaries for use with PRO/5, Visual PRO/5, BBxPROGRESSION/4, and TAOS: The Developer's Workbench. Additionally, it can define SQL Views for use by the BASIS ODBC Driver. DDBuilder runs under Microsoft Windows 95 and NT 4.0.

What is a Data Dictionary?

A data dictionary is an organized, formal description of data files that describes physical file attributes, such as record lengths and file types, as well as logical file attributes, such as column names and output masks.

Applications can be designed to query a data dictionary at run time, which eliminates the reliance on hard-coded program data structures. Because the application code can be data independent, data dictionaries can eliminate the necessity of changing I/O lists and string references in numerous programs. Rather, one change is made to the data dictionary, and a simple file update program is run.

What can be done with DDBuilder?

DDBuilder lets the user exploit the power and convenience of a data dictionary without having to spend the time and resources to create a custom data dictionary utility.

The following can be done using DDBuilder:

  • Create and define data structures.

  • Open data dictionaries created in other applications, and modify them for use with BASIS products.

  • Create and define SQL views for the BASIS ODBC Driver.

  • Print a representation of the database structure and contents.

See Also

Using DDBuilder

Setup Files

Overview

DDBuilder Menu Bar

Creating a New Data Dictionary

Opening an Existing Data Dictionary

Saving a Data Dictionary

Closing a Data Source

Exiting DDBuilder

Adding Elements to a Data Dictionary

Inserting Columns into a Data Dictionary

Copying Data Dictionary Elements to the Clipboard

Pasting Data Dictionary Elements from the Clipboard into a Data Dictionary

Deleting Elements from a Data Dictionary

Reversing/Reinstating the Last Modification to a Data Dictionary Element

Renaming Data Dictionary Items

Defining General Data Sources

Defining General Table Attributes

Defining General Column Attributes

Defining the Index Structure

Defining Advanced Table Options

Defining Table Form and Process Attributes

Defining Application-Specific Table Attributes

Selecting Rules for Tables

Editing Table Rules

Overview

Defining Column Input Attributes

Defining Column Output Attributes

Defining Application-Specific Column Attributes

Selecting Rules for Columns

Editing Column Rules

Defining General Rules

Overview

Defining General Typedef Attributes

Defining Typedef Input Attributes

Defining Typedef Output Attributes

Defining Application-Specific Typedef Attributes

Selecting Rules for Typedefs

Editing Typedef Rules

Overview

Defining Views for Use with Normalized Data

Defining Views for Use with Non-Normalized Data

Example 1: Defining the V_CUSTOMER View

Example 2: Defining the V_ORDER View

Print Setup

Print Preview

Printing the Tree View