Data Transformation Engine Database Interface Designer Reference Guide

Index E
Database Interface Designer Reference Guide
168
DBSelect and DBTable types, 75
debugging
using native tools, 166
delimited Row type
example, 84
rules, 77
E
Edit menu, 20
commands, 20
events
classes, 140
conditions to be met, 141
defining for triggers, 138, 140
modifying or deleting for triggers, 139
specifying
AND or OR condition, 141
different classes, 140
tables, 137
When expression, 141
examples
native call for stored procedures
Oracle adapters, 129
execution audit log, 144
F
file extension
.dbl, 68
.log, 144
.mtt, 47
File menu, 17
commands, 17–19
Find dialog box, 70
fields, 70
fixed Row type rules, 78
G
Generate Type Tree from Queues dialog box
fields, 58–61
Generate Type Tree from Stored Procedures
dialog box
fields, 53–56
Generate Type Trees from Query dialog box
fields, 63–65
Generate Type Trees from Tables dialog box
fields, 48–51
GET function
target trace example, 158
H
Help menu, 25
commands, 25
I
input cards
calling stored procedures, 124
creating for a database, 91
K
key columns
defining, 102
example, 105
general rules, 107
L
log file, 144
M
m4ora8.sql, 131
m4sqlsvr.sql, 131
map
using triggers, 137
MapAudit log file (.log), 144
mdq file
using with DBLOOKUP/DBQUERY, 111
menus
Database, 21
Database Interface Designer window, 16
Edit, 20
File, 17
Help, 25
Query, 23
Tools, 24
View, 20
Window, 24
Mercator Database Interface Designer
window
basics, 11
mtt file, 47
N
Navigator, 12
O
Options dialog box
Confirmations options fields, 30
General option fields, 27
Navigator option fields, 27
Tables/Views option fields, 29
Trace option field, 28
Oracle
using object type parameters for stored
procedures, 128
output cards
calling stored procedures, 128
creating for a database, 94