Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide
33
Index
.
.log file, 32
.mtr, 32
A
audit log, 32
B
Bind facility
limitations, 24
binding
example of, 25
C
column attribute overrides, 19
for queries, 22
for tables and stored procedures, 19
commands
Data Source (-SOURCE), 14
Database Adapter Type (-DBTYPE), 13
for a source, 14
for a target, 17
list of, 12
Row Count (-ROWCNT), 13
summary, 12
D
data types, 7
database definition
ODBC-specific settings, 10
Date & Timeformat, 9
DBLOOKUP or DBQUERY functions, 16
bind limitations when using ODBC, 24
-DBTYPE adapter command, 13
Driver Manager for ODBC, 7
E
error messages, 32
Event Server startup, 26
examples
binding using ODBC, 25
native call for stored procedures, 11
execution commands
-ID, 15
-OD, 17
F
format
data type, 7
date and time, 9
functions
DBLOOKUP/DBQUERY, 16
GET, 16
PUT function, 18
G
GET > Source > Command setting, 14
GET function, 16
I
-ID execution command, 15
Input Source - Override - Database execution
command (-ID), 15
item formats, 7
L
log file, 32
N
native call for stored procedures, 11
O
-OD execution command, 17
Output Source Override - Database execution
command (-OD), 17
P
PUT > Target > Command setting, 17
PUT function, 18
Q
query
defining attribute overrides for, 22
R
RDBMS, 7
related references, 4
restrictions and limitations, 31
return codes, 32
-ROWCNT adapter command, 13
rules for binding, 24