Go to Glossary Search VisualAge C++ Help Go to VisualAge C++ Help Home Page Go to WWW VisualAge C++ Site

Select Database and Mapping Method

In this step of the SmartGuide sequence, you select the database:

  1. Click the drop-down list for Database source and select the type of data source for the database that you want to use (DB2 or ODBC).
  2. The Databases list contains the databases you can access for the mapping. Click the database with which you want to work.

You then specify how you want to map the database tables:

  1. Select one of the radio buttons to specify the type of schema that you want to map from:

    By selecting database tables or views
    If you want to create mappings for database tables or views, choose this option. This is a fast way to create schema mappings. Before code generation, you can customize these mappings in the Data Access Builder window, for example to delete attribute mappings for columns that you do not require.

    By entering an SQL statement
    If you want to create a mapping from an SQL statement that you specify, choose this option. With this selection, you can create a mapping from a complex SQL query which can include table joins, unions, and column functions. You will be able to enter the SQL statement in a later SmartGuide step.

    By importing a Data Access Builder session from a .dax file
    If you have an existing .dax file that you want to import (either exported from a Data Access Builder session or from a previous version of Data Access Builder), choose this option. On the next page, enter the path and file name for the .dax file. This file will be imported into the Data Access Builder session, replacing the existing session if there was one. Note: The .dax file does not include generated code files, but rather only schema and mapping information. Code files can be generated once the session is imported.

  2. Click Next>> to move to the next step.


Data Access Builder Workflow


Start the SmartGuide
Next SmartGuide Step: Select Database Access Method
Import a Data Access Builder Session


Data Access Builder SmartGuide