Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees

Database Interface Designer Reference Guide

Field Description

Override Column

Definitions

(For ODBC only) This check box indicates whether the

database driver (with the check box disabled) or a

command line override (with the check box enabled) is

used to interpret columns. The default value is disabled.

For more information about this field, refer to the

adapter-specific documentation in each adapter

reference guide.

Generate type

trees in Mercator

1.4.0 format

(For Oracle adapter only) This check box determines

whether you can generate type trees that are compatible

with Mercator Software Version 1.4.0 maps. You might

enable this functionality if you have legacy 1.4.0 maps

that you want to maintain for some reason. The default

value is disabled.

For more information about this field, refer to adapter-

specific documentation in each adapter reference guide.

Represent

date/time columns

as text items

This check box determines whether to automatically

format this information in its database-specific date and

time format (enabled) or as a text string (disabled).

Note If you enable this check box (generating date and

time as a text string), you may have to use either

the TEXTTODATE or TEXTTOTIME function in a

map rule to convert the text string to the

database-specific date and time format.

If you are generating new type trees, make sure this

check box is disabled. The default is disabled.

Note Because of adapter-specific differences in date

and time formats, refer to the adapter-specific

instructions in each adapter reference guide.

Treat text item as This list displays the languages available in which to

handle text items. The default value is Western.