Data Transformation Engine Resource Adapter Reference Guide

Resource Adapters Reference Guide
96
Index
.
.mdq
(-M or -MDQ) adapter command, 63, 64
as input to mtsmaker, 74
specifying adapter commands, 27
A
adapter commands
.mdq file (-M or -MDQ), 63, 64
Audit Card (-A or -AUDIT), 58
Bad Data (-BD or -BADDATA), 59
Commit by Card (-CC or -CCARD), 60
Commit by Statement (-CS or -CSTMT), 61
-CONNECT, 59
Data Source (-DS or -SOURCE), 63
Database Adapter (-DT or -DBTYPE), 62
Database Name (-DN or -DBNAME), 62
Delete (-D or -DELETE), 61
example of
not using an .mdq file, 23
overriding, 27
using an .mdq file, 27
File (-F or -FILE), 63
Global Transaction Management (-GTX), 64
Password (-PW or -Password), 65
Query (-Q or -QUERY), 65
Row Count (-RC or -ROWCNT), 66
SQL Statement (-S or -STMT), 67
Stored Procedure Name (-PR or -PROC), 65
syntax
in functions, 56
Table Name (-TB or -TABLE), 67
Trace (-T or -TRACE), 67
Trace Error (-TE or -TRACEERR), 68
Update (-UP or -UPDATE), 71
User ID (-US or -USER), 71
using
-CSTMT for data commitment, 61
Variable (-V or -VAR), 72
adapter use, 20
GET function, 29
in a map or component rule, 22
in the integration flow designer, 23
in the Map Designer, 21
on the command line, 26
PUT function, 29
RUN function, 30
adapters, 9
command aliases, 11
configuring java-based adapters, 14
database-specific messages, 90
FetchUnit interpretation, 31
general messages, 88
general rules, 10
multiple versions of, 12
Scope settings, 31
Source settings, 52
Target settings, 52
using wildcards in, 30
adapters.xml file
editing, 13
multiple adapter versions, 12
aliases, 11
Application adapter, 51
Audit Card (-A or -AUDIT)
adapter command, 58
B
Bad Data (-BD or -BADDATA)
adapter command, 59
binary mode
for transferring .mdq file, 74
for transferring .mts file, 73
C
Category Type (-N)
mtsmaker parameter, 79
command line
using UNIX sources and targets, 28
using Windows sources and targets, 28
Commit by Card (-CC or -CCARD)
adapter command, 60
Commit by Statement (-CS or -CSTMT)
adapter command, 61
configuring java-based adapters, 14
-CSTMT adapter command
using for data commitment, 61
D
Data Source (-D)
mtsmaker parameter, 78
Data Source (-DS or -SOURCE)
adapter command, 63
Database Adapter (-DT or -DBTYPE)
adapter command, 62
Database Adapter (-V)
mtsmaker parameter, 80