Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
167
Index
.
.dbl file, 68
creating, 146
logging errors only, 160
.log file, 144
.mdq file
using with DBLOOKUP/DBQUERY, 111
.mtt file, 47
A
aliases for columns, 88
arguments
DBLOOKUP/DBQUERY
using dynamic adapter commands, 113
using static .mdq, 112
AS keyword, 88
B
binary column type
example, 83
rules, 81
bind facility
for DBLOOKUP/DBQUERY, 118
bind value
example, 119
C
card
input
calling stored procedures, 124
for a database, 91
output
calling stored procedures, 128
for a database, 94
category
SizedGroup, 81
classes of events, 140
column aliases, 88
column types, 79
binary, 80
example, 83
for expressions, 87
columns to update
defining, 102
example, 108
command access, 16
connection
example, 100
factors, 98
management, 96, 97
rules, 99
sharing, 97
customization options, 16
D
database
as an input in a map, 91
as an output in a map, 94
defining to Database Interface Designer, 37
deleting, 39
editing, 39
examples
columns to update, 108
key columns, 105
log file, 146
trace files, 68
triggers, issues for, 136
triggers, using row-based, 135
triggers, using table-based, 135
updating, 101
database connection
example, 100
management, 97
database data
using, 9
Database Definition window, 35
settings, 35–37
database definitions
printing, 67
Database Interface Designer
generating type trees, 47
startup, 10
Database menu, 21
commands, 21–22
database trace files, 144
database type tree structure, 72
dbl file, 68
creating, 146
logging errors only, 160
DBLOOKUP/DBQUERY
arguments using static .mdq, 111
examples
input to RUN function, 116
obtain multiple columns/rows, 115
obtain single column value, 115
using bind values, 118
DBProcedure type, 90