CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description |
Binary | CHAR | 8 | This date should not be used. It is here for backward compatibility. See VMS DATE/Time. This converts a VMS date into a 23-character string. | |
Binary (Text) | CHAR | -1 | ||
Double | DOUBLE | 8 | VMS Double Real Maxcim Double Real | Double precision floating point (8 bytes). |
Left Separate -> Decimal | DECIMAL | -1 | ||
Left Separate -> Double | DOUBLE | 1-20 | Left Separate | Left Separate Double |
Left Separate -> Integer | LONG | 1-20 | Left Separate | Left Separate Integer |
Longword | INTEGER | 4 | ||
Longword -> Decimal | DECIMAL | 4 | VMS Longword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 5 and 9. | Longword Integer with an implied decimal place (4 bytes). |
Longword -> Double | DOUBLE | 4 | ||
Quadword -> Char | VARCHAR | 8 | ||
Quadword -> Char(DP) | VARCHAR | 8 | ||
Quadword Decimal | CHAR | 8 | VMS Quadword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. | Quadword Integer with an implied decimal place (8 bytes) converts to a SQL String. |
Signed Overpunch -> Decimal | DECIMAL | -1 | ||
Signed Overpunch -> Double | DOUBLE | -1 | ||
Single | REAL | 4 | VMS Single Real Maxcim Single Real | Single precision floating point (4 bytes). |
Text (Expandable) | VARCHAR | 1-30000 | Alphanumeric and symbols. (1-30000 chars). | |
Text (Right Space Padded) | CHAR | 1-30000 | Text Maxcim Yes/No | Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
VMS Date/Time | TIMESTAMP | 8 | VMS Binary Date/Time (8 Bytes) converts to an ODBC Timestamp. | |
VMS Double -> Currency | DECIMAL | 8 | ||
VMS G Float | DOUBLE | 8 | ||
Word | SMALLINT | 2 | ||
Word -> Float | REAL | 2 | ||
Word Double (2) | DOUBLE | 2 | Word converted to double with implied decimal point. | |
Word Numeric -> Decimal | DECIMAL | 2 |