Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
75
Invalid Character(s) Conversion to Type Name
punctuation (other than ~ # % \ ‘ ? _)
example: ^^Total^Amount
replaced with pound sign (#)
becomes: ##Total#Amount
digit (as first character of column name)
example:
1st-Game-of-2
prefixed with pound sign (#)
becomes:
#1st_Game_of_2
Characteristics of the DBSelect or DBTable Type
In each type tree generated by the Database Interface Designer or mtsmaker, an
implied group type represents the results of executing the query or the contents of
the table.
♦ DBSelect
The type tree defines a query used as a data source for a map.