Data Transformation Engine Resource Adapter Reference Guide

Index R
Resource Adapters Reference Guide
98
adapter command, 65
Query Name (-Q)
mtsmaker parameter, 79
R
RDBMS, 54
related references, 6
resource adapters, 8
command aliases, 11
configuring java-based adapters, 14
FetchUnit interpretation, 31
general rules, 10
multiple versions of, 12
Source settings, 31, 52
Target settings, 31, 52
troubleshooting, 53
use
in a map or component rule, 22
in the Integration Flow Designer, 23
in the Map Designer, 20
on the command line, 26
using, 20
using wildcards in, 30
restrictions and limitations, ODBC, 55
return codes, 88
Row Count (-RC or -ROWCNT)
adapter command, 66
RUN function
use in resource adapter, 30
S
Scope card setting
adapter-specific list, 31
Sink adapter, 50
SQL SELECT Statement (-S)
mtsmaker parameter, 80
SQL Statement (-S or -STMT)
adapter command, 67
Stored Procedure Name (-G)
mtsmaker parameter, 78
Stored Procedure Name (-PR or -PROC)
adapter command, 65
syntax
adapter commands in functions, 56
syntax summary, 10
system requirements, 9
non-Windows-based adapters, 9
T
Table Name (-T)
mtsmaker parameter, 80
Table Name (-TB or -TABLE)
adapter command, 67
Text File Importer, 33
defining group properties, 43
defining item properties, 45
delimited format, 47
supported character sets, 34
using, 34
Trace (-T or -TRACE)
adapter command, 67
Trace Error (-TE or -TRACEERR)
adapter command, 68
Tree Script File (-O)
mtsmaker parameter, 79
troubleshooting database-specific adapters, 83
troubleshooting resource adapters, 53
Type Tree File (-F)
mtsmaker parameter, 78
Type Tree Maker, 73
script file, 74
transfer, 73
types pane, 45
U
UNIX
sources and targets on the command line, 28
Update (-UP or -UPDATE)
adapter command, 71
User ID (-U)
mtsmaker parameter, 80
User ID (-US or -USER)
adapter command, 71
V
Variable (-V or -VAR)
adapter command, 72
W
wildcards
using in adapters, 30
Windows
sources and targets on the command line, 28