CONNX Data Integration Suite 14.8.0 | Reference Guide | Data Types | CONNX Data Type Import Codes | Import Codes 80-118
 
Import Codes 80-118
Import Code
CONNX Data Type
SQL Data Type
SQL Length
VMS Equivalent Data Types
Description
80
Noah Date
DATE
6
81
Noah Inverse Date
DATE
6
Site-specific.
82
Noah Time
TIME
4
Site-specific.
83
Byte Bit#0 (2^0 )
BIT
1
Evaluates Byte to a True or False value, and represents it as a bit.
84
Byte Bit#1 (2^1)
BIT
1
This represents bit #2 (2^0) from the byte.
85
Byte Bit#2 (2^2)
BIT
1
This represents bit #3 (2^0) from the byte.
86
Byte Bit#3 (2^3)
BIT
1
This represents bit #4 (2^0) from the byte.
87
Byte Bit#4 (2^4)
BIT
1
This represents bit #5 (2^0) from the byte.
88
Byte Bit#5 (2^5)
BIT
1
This represents bit #6 (2^0) from the byte.
89
Byte Bit#6 (2^6)
BIT
1
This represents bit #7 (2^0) from the byte.
90
Byte Bit#7 (2^7)
BIT
1
This represents bit #8 (2^0) from the byte.
91
Winery Word Date
DATE
6
Site-specific.
92
Winery Plus Word Date
DATE
6
Site-specific. Bytes in reverse order.
93
Winery Long Date
DATE
6
Site-specific.
94
Winery Plus Long Date
DATE
6
Site-specific. Bytes in reverse order.
95
POISE Double
DOUBLE
8
ASCII double left space padded with explicit decimal point and sign.
96
VMS C Date
TIMESTAMP
16
Date, stores number of seconds since 1/1/1970.
97
VMS C Reverse Date
TIMESTAMP
16
VMS C Date with bytes reversed.
98
Word -> Double (2)
DOUBLE
8
Word converted to double with implied decimal point.
99
24bit Pascal Integer
INTEGER
4
24-bit Pascal Integer - 3 bytes.
100
PACKED (A) Decimal -> Double
DOUBLE
8
Packed Decimal of type (A).
101
PACKED (A) Decimal -> Integer
LONG
4
Packed Decimal of type (A).
102
PACKED (E) Decimal -> Double
DOUBLE
8
Packed Decimal of type (E).
103
PACKED (E) Decimal -> Integer
LONG
4
Packed Decimal of type (E).
104
PACKED (F) Decimal -> Double
DOUBLE
8
Packed Decimal of type (F).
105
PACKED (F) Decimal -> Integer
LONG
4
Packed Decimal of type (F).
106
DAI History Date
DATE
6
Date in YYMMDD format subtracted from 999999.
107
DAI History Time
DATE
6
Time in HHMMSS format subtracted from 999999.
108
DAI History Year
SMALLINT
2
Year in YYYY format subtracted from 9999.
109
DAI History Period
SMALLINT
2
Period in PP format subtracted from 99.
110
Left Separate -> Double
DOUBLE
8
Left Separate Left Separate Double
111
Left Separate -> Integer
LONG
4
Left Separate
112
Right Separate -> Double
DOUBLE
8
Right Separate
113
Right Separate -> Integer
LONG
4
Right Separate
114 (1018 for backward compatibility)
VMS G Float
DOUBLE
8
G Float
G Float - 64-bit precision
115 (1019 for backward compatibility)
VMS H Float
DOUBLE
8
H Float
H Float - 128-bit precision
116
Allport Julian Date (4 byte)
DATE
6
Site-specific.
117
Allport Time
TIME
6
Site-specific.
118
National Compressed Double
DOUBLE
8
Compressed Double data type.