Data Transformation Engine SQL/MP Adapter Reference Guide

Date and Time Formats Chapter 3 - Database Columns and Types
SQL/MP Adapter Reference Guide
8
NonStop SQL/MP Data
Type
Interpret as Item Subclass, Presentation Length
SMALLINT Character Number, Integer *
INTEGER Character Number, Integer *
LARGEINT Character Number, Integer *
FLOAT (1 to 22 bits) Binary Number 4
FLOAT (23 to 54 bits) Binary Number 8
REAL Binary Number 4
DOUBLE PRECISION Binary Number 8
DECIMAL Character Number, Decimal *
PIC 9(1-s)V9(s) COMP Character Number, Decimal or Integer
(if scale = 0)
*
PIC 9(1-s)V9(s) Character Number, Decimal *
DATETIME Character Date&Time *
DATE Character Date&Time *
TIME Character Date&Time *
TIMESTAMP Character Date&Time *
INTERVAL Character Text *
* The DBMS dictates the length of this type.
Date and Time Formats
There are two different categories of date and time formats for the NonStop
SQL/MP adapter:
♦ default
♦ available
Note If any of your tables contain a datetime column, or the columns you are selecting
for a type tree are datetime, you need to use mtsmaker to generate your type
trees. (The available section identifies the various NonStop SQL/MP-specific
types.) Otherwise, ODBC-generated trees are compatible with the NonStop
SQL/MP adapter (as described in the default section).