Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure

Database Interface Designer Reference Guide

Defining the Column Type(s)

Each named column in the database has a corresponding item type under the

Column type in the type tree with the same name. For example, if the

DEMO.DEPARTMENT table in the database has three columns

(DEPARTMENT_ID, LOCATION_ID, and NAME), the type tree will have three

identically named items (subject to restrictions described in Special Characters in

Type Names) under the Column type, an example of which follows.

Each item is defined according to the data type and length information returned to

the database adapter by the database driver. For more information about the

correspondence between database data types and item formats, refer to the

specific adapter reference guides.

In the following example, there are property windows for two item types: one

number and one text, with different sizes (21 characters and 50 characters,

respectively). This information was returned by the database driver based upon

the data type and length information of the database.