WebSphere brand Transformation Extender Design Studio

Creating database/query files

About this task

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 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.

When an MDQ file is created, it appears in the Navigator next to the appropriate icon. The Database_QueryFile file name is automatically assigned, along with a sequential number.

To save an MDQ file or rename it:

Procedure

  1. From the File menu, select Save As.

    The Save As dialog appears.

  2. Enter the new file name and select the path.
  3. Click OK.


Feedback