Data Transformation Engine Database Interface Designer Reference Guide

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

Database Interface Designer Reference Guide

Each type tree generated by the Database Interface Designer or mtsmaker for a

database table or query (or a query that calls a stored procedure) will have the

following standard characteristics:

♦ The root of the generated type tree is named Data.

♦ The generated type tree contains a category whose name corresponds to any

one of the following:

! the name of the table in the database

! the name of the query in the .mdq file

! the name specified using the Category Type (

-N) parameter for mtsmaker

The types defining the columns and rows returned by the database adapter

stem from this type. In the examples, the categories are ActiveProjects and

stores.

♦ Stemming from the category named for the table or query are types that

define the contents of the table or the results of query execution.

♦ Each column in the database table or in the results of the query must have a

corresponding item type with a name identical to that of the column in the

database. These types stem from an item type (shown in each example)

named Column.

♦ A group type named Row represents a single row of data—either the result of

a SELECT statement or a row to be inserted/updated in a table or view.

♦ An implied group represents a collection of rows reflecting the results of a

query, table, or view. This group is named either DBSelect for a query or

DBTable for a table or view (or DBProcedure for a stored procedure.

Special Characters in Type Names

Some characters used in column names are not valid within type names. The

Database Interface Designer replaces these characters when it creates the type

name for the column. If you create a type tree without using the Database

Interface Designer or mtsmaker, you need to replace these characters in the

type name.

Note Again, if you use the Database Interface Designer, these conversions are

automatically performed. If you use mtsmaker, you must manually convert these

characters.

Invalid Character(s) Conversion to Type Name

space or hyphen (-)

example:

My Column Name

replaced with underscore (_)

becomes:

My_Column_Name