Data Transformation Engine Resource Adapter Reference Guide

Contents
Resource Adapters Reference Guide
4
Text File Importer...........................................................................................33
Supported Character Sets.............................................................................34
Running the Text File Importer ......................................................................34
Delimited Format.......................................................................................47
Sink Adapter..................................................................................................50
Using the Sink Adapter.................................................................................50
Application Adapter.........................................................................................51
Chapter 3 - Source and Target Card Settings
Source Settings...............................................................................................52
Target Settings...............................................................................................52
Chapter 4 - Troubleshooting Resource Adapters
Chapter 5 - Database-specific Adapter Information
Overview ......................................................................................................54
Restrictions and Limitations.......................................................................... 55
Using Database-specific Adapters ........................................................................56
Adapter Usage in Functions...........................................................................56
Adapters in Input Data and Output Data Settings.................................................56
List of Commands............................................................................................56
Audit (-A or -AUDIT).................................................................................... 58
Bad Data (-BD or -BADDATA)..........................................................................59
Connect String (-C or -CONNECT).................................................................... 59
Commit by Card (-CC or -CCARD).................................................................... 60
Commit by Statement (-CS or -CSTMT) .............................................................61
Delete (-D or -DELETE).................................................................................61
Database Name (-DN or -DBNAME)................................................................... 62
Database Adapter Type (-DT or -DBTYPE)..........................................................62
Data Source (-DS or -SOURCE)........................................................................ 63
Database/Query File (-M or -MDQ) .................................................................. 63
File (-F or -FILE) ........................................................................................63
Global Transaction Management (-GTX)............................................................64
Database/Query File (-M or -MDQ) .................................................................. 64
Password (-PW or -PASSWORD)....................................................................... 65
Stored Procedure Name (-PR or -PROC) ............................................................65
Query (-Q or -QUERY)..................................................................................65
Row Count (-RC or -ROWCNT) ........................................................................66
SQL Statement (-S or -STMT) ......................................................................... 67
Table Name (-TB or -TABLE)..........................................................................67
Trace (-T or -TRACE)................................................................................... 67
Trace Error (-TE or -TRACEERR)......................................................................68
Trigger (-TR or -TRIG).................................................................................. 69
Update (-UP or -UPDATE) .............................................................................71
User ID (-US or -USER) .................................................................................71
Variable (-V or -VAR)...................................................................................72
Chapter 6 - Generating Type Trees Using mtsmaker
Overview ......................................................................................................73
Generating a Tree Script ...................................................................................74
Using mtsmaker with a Database/Query File...................................................... 74