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. |