Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
76
♦ DBTable
The type tree defines a table used as a data target for a map.
The DBSelect or DBTable type is an implied group with a series of row objects as
its only component.
Components and Format of the Row Type
As its name implies, the Row group represents a row (or tuple). The Row type is
a group with an explicit format. The syntax of that format is based upon the
options specified when the tree was created from the Database Interface Designer
or the value passed to mtsmaker using the Format mtsmaker command (
-X).
Refer to the following table for information about specifying the value for the Row
group format list when generating a type tree for a query or table.
Using Information
Database Interface Designer Chapter 3 - Database/query Files
mtsmaker Resource Adapters Reference Guide
There are two different row group formats:
♦ Delimited
♦ Fixed
You can specify the syntax for each of these when generating the type tree.