Data Transformation Engine Resource Adapter Reference Guide

Index E
Resource Adapters Reference Guide
97
Database Adapter (-Z)
mtsmaker parameter, 81
Database Interface Designer
installation, 54
Database Name (-B)
mtsmaker parameter, 78
Database Name (-DN or -DBNAME)
adapter command, 62
Database/query File (-M)
mtsmaker parameter, 78
database-specific adapter messages, 90
database-specific adapters
troubleshooting, 83
define group properties, 42
Delete (-D or -DELETE)
adapter command, 61
E
examples
adapter commands
overriding, 27
using an .mdq file, 27
without an .mdq file, 23
F
FetchUnit input card setting
adapter-specific interpretation, 31
File (-F or -FILE)
adapter command, 63
File adapter, 33
file extensions
.mts, 33
files
mts, 74
transferring
.mdq, 74
.mts, 73
Format (-X)
mtsmaker parameter, 81
functions
syntax for adapter commands, 56
G
general adapter messages, 88
GET function
use in resource adapter, 29
Global Transaction Management (-GTX)
adapter command, 64
group properties, define, 42
I
-ID execution command, 26
import data, 35
importers, 9
J
java-based adapters, 14
M
mdq file
(-M or -MDQ) adapter command, 64
as input to mtsmaker, 74
specifying adapter commands, 27
Mercator 1.4.0 format type tree, 81
messages, 88
mts file, 74
transferring of, 73
mtsmaker, 73
example
with .mdq file, 75
without .mdq file, 76
modes, 74
parameters
Category Type (-N), 79
Data Source (-D), 78
Database Adapter (-V), 80
Database Adapter (-Z), 81
Database Name (-B), 78
Database/query File (-M), 78
Format (-X), 81
general rules of, 76
Password (-P), 79
Query Name (-Q), 79
SQL SELECT Statement (-S), 80
Stored Procedure Name (-G), 78
Table Name (-T), 80
Tree Script File (-O), 79
Type Tree File (-F), 78
User ID (-U), 80
using with .mdq file, 74
without using .mdq file, 75
O
-OD execution command, 26
ODBC, restrictions and limitations, 55
Oracle adapter commands
-CONNECT, 59
Oracle Connect (-C or -CONNECT)
adapter command, 59
P
Password (-P) mtsmaker parameter, 79
Password (-PW or -Password)
adapter command, 65
PUT function
use in resource adapter, 29
Q
Query (-Q or -QUERY)