What
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
Creating a New Data Dictionary
Opening an Existing Data Dictionary
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 Table Attributes
Defining General Column Attributes
Defining Advanced Table Options
Defining Table Form and Process Attributes
Defining Application-Specific Table Attributes
Defining Column Input Attributes
Defining Column Output Attributes
Defining Application-Specific Column Attributes
Defining General Typedef Attributes
Defining Typedef Input Attributes
Defining Typedef Output Attributes
Defining Application-Specific Typedef Attributes
Defining Views for Use with Normalized Data
Defining Views for Use with Non-Normalized Data
Example 1: Defining the V_CUSTOMER View