Data Transformation Engine Database Interface Designer Reference Guide

Contents
Database Interface Designer Reference Guide
5
Issues for Both Row- and Table-Based Triggering................................................136
Issues for Row-Based Triggering Only ..............................................................136
Defining a Trigger Using a Database Source ......................................................136
Using a Database as a Map Trigger ..................................................................... 137
Defining a Trigger for a Query.......................................................................137
Defining Events.........................................................................................140
Specifying a Combination of Different Event Classes ............................................... 140
Specifying AND or OR .................................................................................141
Specifying When .......................................................................................141
Specifying Triggers on the Command Line ............................................................ 143
Using the Integration Flow Designer to Enable Triggers............................................ 143
Chapter 10 - Debugging and Viewing Results
Troubleshooting Tools .................................................................................... 144
Database Trace Files...................................................................................... 144
Format of Database Trace Files.....................................................................145
Producing the Database Trace in the Database Interface Designer ..........................146
Producing the Database Trace During Map Execution...........................................148
Tracing Database Errors Only........................................................................160
Viewing Database Source and Target Data............................................................ 163
Using Backup Settings.................................................................................163
Capturing Data Not Processed.......................................................................163
Database Audit Files ...................................................................................... 164
DBMS Trace Utilities and SQL Command Tools ....................................................... 166
Trace Utilities..........................................................................................166
SQL Command Tools...................................................................................166
Index