Data Access Builder
Data Access Builder is an application development tool that you can use to create data
access classes customized for your existing relational database tables. You invoke Data
Access Builder as part of a project from the IBM VisualAge C++ Integrated Development
Environment, and you use it to generate C++ source code (classes) to access data. These Data Access classes can be used directly in your C++
programs to perform database access. These classes or parts can also be used with the
Visual Composition tool to create graphical user interface (GUI) programs. As a result,
you can create object-oriented applications quickly and reliably.
Highlights in this Release
Here is a summary of new features in this release of Data Access Builder:
- A SmartGuide that helps you quickly create mappings for your database tables.
- Flexibility in specifying data source, for example to create mappings from SQL
statements. Table joins, unions and database functions can be used in these SQL
statements.
- User-friendly visual presentation of mappings that allow you to:
- See mappings with all their attributes in a tree structure
- Do visual editing such as deleting the schema, mapping, or attribute icons.
- See broken user-defined methods in the mapping
- A choice of C++ data types to which you can map an SQL type, including the use of
CURRENT DATE, TIME or TIMESTAMP for time-related attributes.
- Classes and methods that allow you to use a cursor to fetch rows from database queries
that return result sets.
- Support for defining your own methods that return either single values or a collection
of rows. You define the methods using SQL, and they are added to the generated classes.
- Access to database stored procedures via C++ methods in the generated classes.
- Optional suppression of default add, retrieve, and delete methods in the generated code.
- Support for creating mappings from schemas such as table joins and keyless tables.
- Background thread support for the generated methods.
- Multiple database connections with code generated for ESQL.
- More samples to demonstrate how to create the Data Access Builder mapping and use the
generated classes.
Data Access Builder Features
Some of the key features of Data Access Builder are:
- DB2 or ODBC to access your database
Data Access Builder generates code that uses DB2 Universal Database or ODBC drivers to
access your database.
- Flexibility in specifying data source
Data Access Builder generates code from database tables, from database views, or from SQL
statements that you enter.
- ESQL or CLI code
Data Access Builder generates DB2 Embedded SQL, DB2 CLI, or ODBC code to access your data.
- User-friendly visual editing
Data Access Builder uses icons for attributes and allows visual editing for such actions
as deleting an attribute mapping.
- Quick and simple to use
You can simply specify a database table name and Data Access Builder can access the table
information and generate C++ source code that allows you to add, update, delete, or
retrieve rows in that table.
- Customize to your requirements
For special requirements, you can customize your specifications in Data Access Builder
before code generation. Customization can be as simple as deleting unused attributes, or
as complex as adding your own methods. A common example of customization is to change an
attribute's C++ data types. With the Data Access Builder, not only can you do this but you
can also specify that CURRENT DATE, TIME or TIMESTAMP are used for time-related attributes
when updating or adding rows in the database.
- Data manipulation operations
Generated classes customized to your data help you perform common database tasks such as
adding, retrieving, updating, and deleting data. Classes are also generated to allow you
to use a cursor to fetch rows from database queries that return result sets.
- Visual Composition with the generated classes
Data Access Builder generates C++ classes which can be used by the Visual Composition tool
that is available with the VisualAge C++ product. You can quickly create customized visual
applications by using the Data Access Builder's nonvisual classes. A sample is provided to
demonstrate how this can be done.
- Add your own methods
You can add your own methods to generated classes by typing SQL statements; Data Access
Builder generates the C++ source code for you. For example, you can add a method to update
one of the tables in a table join mapping.
- Stored procedure support
You can use Data Access Builder to generate code that calls stored procedures. Data Access
Builder allows you to connect to the database to retrieve its stored procedure's
information or to provide the information off-line.
- Generate code for table joins
You can specify table joins using SQL statements, and Data Access Builder generates
C++ classes to let you process the returned result set.
- Connection and transaction services
Separate services are provided for connection and disconnection from your databases. In
addition, commit and rollback methods are generated to handle transaction services.
- Background thread support
Generated methods, including methods you have defined, can run on a background thread by
enabling asynchronous mode on the objects. You can improve the performance of your
applications by running methods asynchronously.
- Easy-to-use samples
A set of small C++ applications are shipped with the product to enable you to quickly
learn how to create mappings and use the generated code to access databases.
Data Access/Visual Builder Tutorial
Creating a Visual Data Access Application -
Follow the instructions in this tutorial to create a basic data access application
visually.

Data Access Builder Workflow
User-Defined Methods
Table Joins and Query Support
Large Object Support

Data Access Class Library and Generated Class Reference
Data Access Builder Samples

Change Attribute Properties