Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide

Chapter 5 - Overriding Column

Attributes

When using the Database Interface Designer to generate a type tree for a query,

table, view, or stored procedure, you may want to specify how columns are to be

interpreted, rather than relying upon the interpretation of a particular database

driver.

These column overrides are saved in the .mdq file. When generating a type tree

with the ODBC adapter and enabling the Override Column Definitions check

box in the Generate Type Tree from dialog box for a query, table, view, or

stored procedure, the Column Datatype Specification dialog box appears. Any

overrides you specify in these dialog boxes are saved when the .mdq file is saved.

Note The generated type tree with overrides is represented in the Navigator with an

icon having black spheres (instead of blue, red, and green).

If a tree is regenerated at a later date for the same query, table, view, or stored

procedure within a database, you are prompted to confirm whether the previously

defined overrides should be applied to the new tree.

Note The following steps and dialog boxes show how to define column override

attributes for a table or view. However, the steps and dialog boxes for a stored

procedure are very similar and should follow the same process.

Defining Column Attribute Overrides

The following procedure describes how to define column attribute overrides for a:

♦ table or stored procedure

♦ query

To define column attribute overrides for a table (or stored procedure)

1 In the Database Interface Designer, open the .mdq file.

2 In the Navigator, select the database containing the table for which you want

to generate a type tree with column attribute overrides.