Data Transformation Engine SQL/MP Adapter Reference Guide

SQL/MP Adapter Reference Guide

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 NonStop SQL/MP-

compliant Relational Database Management System (RDBMS). Item types will be

created in a type tree that represents 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/MP to describe the columns associated with a query, table,

or view. NonStop SQL/MP 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/MP 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/MP data types and the values of the

item type properties to which they correspond when the type tree is generated.

NonStop SQL/MP Data

Type

Interpret as Item Subclass, Presentation Length

CHAR Character Text *

PIC X Character Text *

CHAR VARYING Character Text *

VARCHAR Character Text *

NCHAR Character Text *

NUMERIC Character Number, Decimal or Integer

(if scale = 0)