Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
33
Chapter 3 - Database/query Files
This chapter discusses how to use the Database Interface Designer when working
with .mdq files to perform the following types of tasks:
♦ Create .mdq files.
♦ Define the various objects included in an .mdq file. (For more information
about such objects as queries and variables, refer to Defining a Query and
Defining Variables in SQL Statements.)
♦ Generate type trees. (Refer to Generating Type Trees.)
♦ Print reports and enable trace functionality. (Refer to Printing Reports and
Database Interface Designer Trace Files.)
Creating Database/Query Files
An .mdq file contains the definitions for one or more databases, as well as
queries, stored procedures, and other specifications, that may contribute to the
execution of a map. Use the commands on the File menu in the Database
Interface Designer to create and save a database/query file with an .mdq file
extension. This file name and path appears in the title bar of the Mercator
Database Interface Designer window when it is the selected file in Navigator,
indicating that it is the active .mdq file.
After starting the Database Interface Designer, the Navigator lists one or more
.mdq files depending upon whether your selection was to create a new .mdq file
or to open one or more existing files.