Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
3
Contents
About This Document
Related References........................................................................................... 6
Chapter 1 - Introduction
Overview ....................................................................................................... 8
Installation..................................................................................................... 9
Basic Steps for Using Database Data ...................................................................... 9
Chapter 2 - Basics
Starting the Database Interface Designer ...............................................................10
Mercator Database Interface Designer Window ........................................................11
The Navigator ...........................................................................................12
Help ............................................................................................................16
Menu Commands and Tools ................................................................................16
Menu ...................................................................................................... 16
Toolbar ...................................................................................................17
Configuring the Environment..............................................................................26
Tools > Options.......................................................................................... 26
Shortcut Keys............................................................................................ 32
Chapter 3 - Database/query Files
Creating Database/Query Files............................................................................33
Defining a Database.........................................................................................35
Defining a Query.............................................................................................38
Editing or Deleting a Database or Query ................................................................39
Comparing Database/query Files .........................................................................39
Criteria For Analyzing Differences...................................................................40
Creating a Database/query File Comparison.......................................................40
Viewing Database/query File Differences..........................................................41
Defining Variables in SQL Statements....................................................................45
Defining a Query with Variables .....................................................................45
Specifying the Values at Runtime....................................................................46
Generating Type Trees .....................................................................................47
From a Table or View ..................................................................................47
From a Stored Procedure..............................................................................52
From a Message Queue (Oracle8 AQ)................................................................58
From a Query............................................................................................62
Printing Reports..............................................................................................66
Database Interface Designer Trace Files ................................................................68
Database Interface Designer Trace..................................................................68
Viewing Database Interface Designer Trace Files.................................................69
Using Find in Trace Files ..............................................................................69
Chapter 4 - Database Type Trees
Table and Query Type Tree Structure ...................................................................73
Special Characters in Type Names................................................................... 74
Characteristics of the DBSelect or DBTable Type.................................................75