Data Transformation Engine Database Interface Designer Reference Guide

Index U
Database Interface Designer Reference Guide
170
using native tools, 166
type tree file, 47
type trees
comparison of structures, 89
for stored procedures, 124, 127
generating
from a query, 66
from a queue, 59, 61
from a stored procedure, 57
from a table, 51
from a view, 48, 52
using Database Interface Designer, 47
query and table structure, 73
stored procedure structure, 89
type name rules, 74
types
column, 79
binary, 80
columns for expressions, 87
DBSelect and DBTable, 75
ProcedureCall, 89
Row, 76
delimited format, 77
fixed format, 78
U
update columns
definition, 107
example, 108
update keys
columns to update, 107
definition of, 101
examples
columns to update, 108
key columns, 105
key column general rules, 107
specifying update mode, 103
update mode
specifying in the Map Designer, 103
specifying on the command line, 104
V
values
returned from stored procedures, 123, 125
variables
passing values at run time, 46
syntax for defining in a query, 45
view
generating a type tree, 48, 52
View menu, 20
commands, 20
W
When expression, 141
formats used for, 142
table column format example, 142
table SELECT 1 FROM format example, 142
Window menu, 24
commands, 24