Data Transformation Engine ODBC Adapter Reference Guide

Chapter 5 - Overriding Column Attributes Defining Column Attribute Overrides
ODBC Adapter Reference Guide
21
8 Accept the default values for the Group options fields (Delimiter,
Terminator, and Release) or change as desired.
9 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.
10 Click Generate.
The Column Datatype Specification dialog box appears, an example of
which follows.
11 From the Tables/Views list, select the table or view containing the column or
columns for which you want specify an override.
12 From the Columns list, select the column for which you want to specify an
override.
13 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.
14 Repeat Steps 11-13 for each column for which you want to specify an override.