Data Transformation Engine SQL/MX Adapter Reference Guide

SQL/MX Adapter Reference Guide
7
Chapter 3 - Database Columns and
Types
The Database Interface Designer and mtsmaker with the Type Tree Maker
generate type trees for queries, tables, and views in an SQL/MX-compliant RDBMS
(Relational Database Management System). Item types will be created in a type
tree that represent the data types of the columns of a query, table, or view.
The Database Interface Designer and mtsmaker get information about columns
by calling NonStop SQL/MX to describe the columns associated with a query,
table, or view. NonStop SQL/MX returns the data type, length, and other
information to the Database Interface Designer and mtsmaker. The Database
Interface Designer and mtsmaker then map the NonStop SQL/MX data types to
item types in a type tree.
Note Type trees for messages can be generated only using the Database Interface
Designer. For more information, refer to the Database Interface Designer
Reference Guide.
Item Type Properties
The following table lists the NonStop SQL/MX data types and the values of the
item type properties to which they correspond when the type tree is generated.
NonStop SQL/MX Data
Type
Interpret as Item Subclass, Presentation Length
CHAR Character Text *
PIC X Character Text *
CHAR VARYING Character Text *
VARCHAR Character Text *
NUMERIC Character Number, Decimal or Integer
(if scale = 0)
*
SMALLINT Character Number, Integer *