Defining a database target in the map designer

Edit online

About this task

When you generate the type tree for a table, view, message queue, or stored procedure, one of the types in the tree is a group representing the contents of the table, view, message queue, or stored procedure. For example, a type tree generated for a table or view is named DBTable. Use the Map Designer to select the appropriate type representing the contents as the output card type of the executable map.

After you have defined the database and have generated the type tree, using a database as an output is very similar to using a file as output.

Use the Map Designer to specify Database as the PUT > Target setting in the output card at the executable map level. Provide the name of the MDQ file containing the definition of the database, along with the table, view, message queue, or stored procedure to be used.

To define a database as a target:

Note: For more information about the map settings in this procedure, see the Map Designer documentation. This procedure specifically addresses database-specific parameters and settings.

Procedure

  1. In the Map Designer, select the To window.
  2. From the Card menu, select New.
    The Add Output Card dialog is displayed, an example of which follows.
  3. For the CardName setting, enter a name for the card.
  4. For the TypeTree setting, select the type tree file containing the group type that defines the content of the desired output.
  5. For the TypeName setting, select the group type from the type tree that defines the desired output (for example, DBSelect).
  6. Specify all Backup settings as desired. For detailed information about these settings, see the Map Designer documentation.
  7. For the PUT > Target setting, select Database from the list.
    The settings displayed in the Output Card dialog change to display the database adapter settings for a target. For database adapter-specific information about target settings, see the adapter-specific reference guide.
  8. Specify the values as desired in the adapter settings and click OK.