Data Transformation Engine Database Interface Designer Reference Guide

Index P
Database Interface Designer Reference Guide
169
P
Print dialog box, 67
ProcedureCall type, 89
Q
query
defining triggers, 137
defining with variables, 45
generating a type tree, 66
text using a stored procedure, 126
type tree structure, 73
Query menu, 23
commands, 23
queues
generating a type tree, 59, 61
R
RDBMS, 8
related references, 6
Row type
delimited, 77
examples, 84
fixed, 78
row-based triggers, 135
rules
binary column type, 81
delimited Row type, 77
fixed Row type, 78
for type names in type tree, 74
key columns, 107
S
SELECT statements in queries, 38
size of item types for columns in a row, 80
Sized attribute, 82
SizedGroup category, 81
source
examples
tracing, 150
source examples
tracing, 149
special characters in type names, 74
SQL command tools, 166
starting the Database Interface Designer, 10
Startup Window, 10
status bar, 20
stored procedures
calling in output cards, 128
calling with object type parameters
Oracle, 128
generating a type tree, 57
in query text, 126
methods of calling, 121
returning values from, 123
type tree structure, 89
using as input, 124
using as output, 127
syntax
bind value in SQL statement, 119
variables in the Database Interface Designer,
45
system definition diagram tools, 17
T
table
generating a type tree, 51
type tree structure, 73
table-based triggers, 135
target
trace examples, 151
missing required value, 153
using -BADDATA, 155
using GET, 158
with -UPDATE off, 157
Toolbar, 17
Tools menu, 24
commands, 24
-TRACE adapter command
using ERROR option, 161
trace examples
.dbl file, 146
for a source, 149, 150
for target, 151
missing required value, 153
using -BADDATA, 155
using GET, 158
with -UPDATE off, 157
transactional control, 96
triggers
databases supporting, 130
defining events, 138, 140
event conditions, 141
installation requirements for, 131
issues for, 136
maintaining triggering tables for, 133
modifying or deleting events, 139
row-based, 135
specifying
AND or OR condition, 141
different event classes, 140
tables, 137
When expression, 141
table-based, 135
tables created for, 132
types of, 131
using a database, 137
using a query, 137
troubleshooting
tools, 144