Data Access Builder Window
The Data Access Builder window allows you to
view and customize the schema mapping. The schema mapping is
created by the Data Access Builder SmartGuide to store
information to generate code. The window has a menu bar:
- File
- Map schema -
Select to create a new schema mapping. The
SmartGuide is invoked when you select this
option.
- Save - Select to
save the current session. This updates the IDE
and Data Access Launch view, and generates .vbe
and .vbf files for the Data Access part. The Data
Access part files are saved to the project's
working directory.
- Generate - Select
to generate code for all mappings.
- Import - Select
to import a Data Access Builder session that will
replace the current session (that is,
the current session will be lost).
- Export - Select
to save the current Data Access Builder session
to the desired location.
- Exit - Select to
end the Data Access Builder session.
- Selected - Shows the
valid actions for the selected icon. These items are also
available in the icon's popup menu.
- View
- Information line
- Enable to view the information line at the
bottom of the window.
- Options
- Confirm delete -
Enable to get a warning prompt before a deleting
an icon.
- Help
- Help Home Page -
Select to display the main window for the product
information.
- Concepts - Select
to display the concepts information for the
product.
- Tasks - Select to
display the procedures information for the
product.
- Reference -
Select to display the reference information for
the product.
- Tutorial - Select
to start the tutorial for the product.
- Glossary - Select
to display the glossary terms for the product.
- Search - Select
to search for information.
- Samples - Select
to display the list of samples shipped with the
product.
- Help for Help -
Select to display on information on how to invoke
help.
- About VisualAge C++ -
Select to display information on the VisualAge
C++ product.
Schema Mapping
Data Access Builder creates schema
mappings, which contain information for source code generation.
The schema mapping is displayed as a tree view. The schema is a
database object which can be a database table, view, or a logical
grouping of columns specified in an SQL query. The schema is
represented as one of the following icons:
 |
 |
 |
| Schema is a table |
Schema is a view |
Schema is an SQL query |
To view schema information (for example, column
names and SQL types), double-click on the schema icon to open its
properties notebook. The following operations for the schema
object are available from the Selected menu, or
from the schema's popup menu:
- Create mapping to create
a mapping from the selected schema. If you have a choice
of type of mapping (that is, CLI or ESQL), then there is
a Create Mapping option for each choice
you have.
- Stored Procedures to
define, modify, view, or delete stored procedure
definitions.
- Delete to delete the
schema object. Both the schema and its mappings are
deleted.
- Properties to view the
schema properties (same as double-clicking on the icon).
Each schema may have zero or more mappings.
Each mapping contains sufficient information for Data Access
Builder to generate C++ classes. For example, it has definitions
for all attributes matching all the columns for your database
table, view, or SQL statement. This mapping is then used to
generate C++ classes that could include add, update, delete, and
retrieve methods. You can also customize the mapping by changing
attribute names or by adding your own methods before code
generation. Under the schema icon, each mapping is visually
represented by this icon:
 |
Mapping icon |
When the source code for the mapping has been
generated, the table piece changes color. When there is an error
in a user-defined method in that mapping, its icon has a red
cross above it
. When you generate classes, the code will not
include methods that have errors.
Double-click on the icon to open its properties
notebook and view information such as generated file names. The
following operations for the mapping object are available from
the Selected menu, or from the mapping's popup
menu:
- Generate to generate
classes for the mapping. The color of the icon changes to
indicate that the code has been generated.
- Methods to open the
Methods window to add or modify user-defined methods for
the <class> object..
- Manager Methods to open
the Manager Methods window to add or modify user-defined
methods in the <class>Manager object.
- Attributes to open the
Attributes window to view or modify attribute mappings.
- Delete to delete the
mapping object.
- Properties to open the
mapping's properties notebook to view or change the
mapping properties (same as double-clicking on the icon).
Attributes
Each mapping defines attributes
for all the columns of the specified database table, view, or SQL
query. When you expand the mapping. The attributes that are
mapped are displayed in the tree structure as the following
icons:
 |
 |
| attribute |
attribute that is a data
identifier |
The following operations for the attribute
objects are available from the Selected menu, or
from the attributes' popup menus:
- Delete to delete the
attribute object. The generated code will not include the
column when its attribute has been deleted. To recreate a
previously deleted attribute, select Attributes
from the mapping icon's menu; then select Map
Column.
- Properties to view or
change attribute's properties, for example its name or
data type (same as double-clicking on the attribute
icon).

Data Access
Builder
Data
Access Builder Workflow

Create
Mappings
Start Data
Access Builder SmartGuide
Import a
Data Access Builder Session
Export a
Data Access Builder Session
Change
Mapping Properties
Change
Attribute Properties
Fix Broken
Mappings

Data Access Builder
SmartGuide