CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description |
Binary | BINARY | 1-30000 | Maxcim RFA Maxcim Byte Array | The binary field is not converted. It provides access to raw, unaltered data in an RMS file. |
Binary (Text) | CHAR | -1 | ||
Double | DOUBLE | 8 | Vms Double RealMaxcim Double Real | Double precision floating point (8 bytes) |
Interval Date/Day/Second | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Hour | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Hour/Minute | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Hour/Second | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Minute | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Minute/Second | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Month | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Second | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Year | DOUBLE | -1 | Rdb Interval data type | |
Interval Date Year/Month | DOUBLE | -1 | ||
Interval Day | DOUBLE | -1 | Rdb Interval data type | |
Interval Hour | DOUBLE | -1 | Rdb Interval data type | |
Interval Minute | DOUBLE | -1 | Rdb Interval data type | |
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 | ||
Longword | INTEGER | 4 | VMS Longword Integer PIC S9(X1) COMP where X1 is between 5 and 9. | Longword Integer (4 bytes) |
Quadword -> Char | VARCHAR | 8 | ||
Quadword -> Char(DP) | VARCHAR | 8 | ||
Quadword -> Decimal | DECIMAL | 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. |
Rdb Date ANSI | DATE | 16 | ||
Rdb Date VMS | TIMESTAMP | 16 | ||
Rdb Date VMS (String) | TIMESTAMP | 16 | ||
Rdb Time | TIME | 16 | ||
Rdb Timestamp | TIMESTAMP | 16 | ||
Signed Overpunch -> Double | DOUBLE | 1 | ||
Single | REAL | 16 | ||
String Tinyint | TINYINT | -1 | ||
String Smallint | SMALLINT | -1 | ||
String Integer | INTEGER | -1 | ||
String Quadword | VARCHAR | -1 | ||
String Single | REAL | -1 | ||
String Double | DOUBLE | -1 | ||
Text (Expandable) | VARCHAR | 1-30000 | Alphanumeric and symbols (1-30000 chars). | |
Text (Null Terminated) | VARCHAR | -1 | ||
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 G Float | DOUBLE | 8 | ||
Word | SMALLINT | 2 |