Data Transformation Engine Database Interface Designer Reference Guide

Contents
Database Interface Designer Reference Guide
4
Components and Format of the Row Type ......................................................... 76
Defining the Column Type(s) ......................................................................... 79
Stored Procedure Type Tree Structure ..................................................................89
Oracle8 AQ Message Type Tree Structure...............................................................90
Chapter 5 - Database Sources and Targets
Using a Database as a Source..............................................................................91
Defining a Database Source in the Map Designer .................................................91
Database GET > Source Settings .....................................................................93
Using a Database as a Target..............................................................................94
Defining a Database Target in the Map Designer.................................................. 94
Database PUT > Target Settings......................................................................96
Database Connections and Transactions.................................................................96
Transactional Control..................................................................................97
Database Connection Management..................................................................97
Connection Example ..................................................................................100
Chapter 6 - Updating Database Tables
Using Key and Update Columns ......................................................................... 101
Defining Key and Update Columns...................................................................... 102
Specifying Update Mode.................................................................................. 103
Using the Map Designer or Integration Flow Designer...........................................103
Using an Adapter Command at Execution Time..................................................104
Example Using Update Key Columns ................................................................... 105
Example Using Update Columns......................................................................... 107
Chapter 7 - Database Functions
Accessing Database Information in a Map Rule....................................................... 110
Using DBLOOKUP and DBQUERY......................................................................... 110
Syntax1 - Using a Static .mdq File..................................................................111
Syntax2 - Using Dynamic Adapter Commands ....................................................112
Using Bind Values in Database Functions.............................................................. 118
Chapter 8 - Using Stored Procedures
Calling Stored Procedures................................................................................ 121
The Database-independent Syntax for Calls ......................................................122
Examples Using Stored Procedures ..................................................................... 122
Returning the Value from a Stored Function .....................................................123
Using a Stored Procedure as an Input.................................................................. 124
Using a Query to Execute a Stored Procedure....................................................126
Using a Stored Procedure as an Output................................................................ 127
Stored Procedures with Object Type Parameters.................................................... 128
Chapter 9 - Database Triggers
Database Triggers Overview ............................................................................. 130
Database Support......................................................................................130
Installation Requirements............................................................................131
Tables Created for Triggering .......................................................................132
Maintaining Triggering Tables .......................................................................133
Table-based Triggering ...............................................................................135
Row-based Triggering.................................................................................135