Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Comparing Database/query Files
Database Interface Designer Reference Guide
43
Query Differences
If there are differences between the two compared .mdq files with regard to query
syntax or column overrides, the name of the query with differences appears in red
letters in the Database Differences window. If the query in each .mdq file is
uniquely named, each query name appears in blue letters.
If each .mdq file has a query with the same name, but containing unique
information, the Query and/or Column Overrides tabs in each lower
windowpane appear in red letters. (If there were no differences, these tabs would
appear in black letters and you would only see one display in the bottom pane at a
time, depending upon where your cursor is in the upper pane.) When the tabs are
red, you can go to each display and see the differences indicated in red letters.
Click the Query and Column Overrides tabs in each pane to view the
differences.
Variable Differences
If the variables of the two compared .mdq files have the same name, but different
settings, the variable name will appear in red letters in the upper pane and both
variables will appear in the bottom panes with the tab letters also in red letters. In
the bottom panes, the unique value(s) will appear in red letters. If the variable
names of either of the two compared .mdq files are different, the name of each
variable appears in blue letters in the Database Differences window. If the
variables are exactly the same, the name of the variable in both the upper and
lower pane and the Variables tab would all appear in black letters.
Click the Variables tab in each pane to view the differences.
Unique Database Information
If the databases of the two compared .mdq files have the same name, but
different settings, this tab will appear in red letters. Also, both databases will
appear in the bottom panes of the Database Differences window. If the
database names of either of the two compared .mdq files are different, the name
of each database appears in blue letters in the Database Differences window. If
the databases are exactly the same, the name of the database in both the upper
pane and the Database Properties tab would all appear in black letters. In both
of these latter scenarios (with the different-named or duplicate databases), you
can view only one tab at a time by clicking on the Database icon in the upper
(Navigator-like) portion of the window for the specific .mdq file. The resulting
display in this tab is a reproduction of the settings of the Database Definition
dialog box. To see the respective database differences, you must click alternately
on each database icon in each upper half of the Database Differences window.