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.