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