Data Transformation Engine ODBC Adapter Reference Guide

Chapter 5 - Overriding Column Attributes Defining Column Attribute Overrides
ODBC Adapter Reference Guide
23
7 Accept the default values for the Group options fields (Delimiter,
Terminator, and Release) or change as desired.
8 To specify how columns are to be interpreted, enable the Override column
definitions check box as opposed to relying on the interpretation of the
database driver.
9 Click OK.
The Column Datatype Specification dialog box appears, an example of
which follows.
10 From the Columns list, select the column for which you want to specify an
override.
11 Specify the Subclass, Interpret as, Presentation, and Length values for
the selected column as desired. For more information about setting these
attributes, refer to the Type Designer Reference Guide.
Note In most cases, the specified length should not be shorter than the
default length because this may result in data truncation errors.
12 Repeat Steps 10–11 for each column for which you want to specify an override.
13 Click OK.