Data Transformation Engine SQL/MX Adapter Reference Guide

Item Type Properties Chapter 3 - Database Columns and Types
SQL/MX Adapter Reference Guide
8
NonStop SQL/MX Data
Type
Interpret as Item Subclass, Presentation Length
INTEGER Character Number, Integer *
LARGEINT Character Number, Integer *
FLOAT (1 to 23 bits) Binary Number 4
FLOAT (24 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 *
* The DBMS dictates the length of this type.