Import Code | CONNX Data Type | SQL Data Type | SQL Length | VMS Equivalent Data Types | Description |
1 (1000) | Text (Right Space Padded) | CHAR | -1 | Text Maxcim Yes/No | Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
2 | Text (Null Terminated) | VARCHAR | -1 | ||
3 | Text (Expandable) | VARCHAR | -1 | Alphanumeric and symbols. (1-30000 chars). | |
4 (1039) | Zero Filled Text | CHAR | -1 | Maxcim Zero-filled String | A zero-filled string is NOT filled if it contains an alpha character, otherwise, it is a zero-filled numeric string. (1-30000 chars) |
5 (1018 for backward compatibility) | VMS Single | REAL | 4 | VMS Single Real Maxcim Single Real | Single precision floating point (4 bytes). |
6 (1017) | VMS Double | DOUBLE | 8 | VMS Double Real Maxcim Double Real | Double precision floating point (8 bytes). |
7 (1026) | Byte | TINYINT | 1 | VMS Byte Integer Maxcim Byte Integer | Byte Integer (1 byte). |
8 (1021) | Byte -> Float | REAL | 4 | VMS Byte Integer with implied decimal. | Byte Integer with an implied decimal place (1 byte). |
9 (1001 for backward compatibility) | Byte Bit (1/0) | BIT | 1 | Evaluates Byte to a True or False value, and represents it as a bit. | |
10 | Byte Bit Text(Yes/No) | CHAR | 3 | Evaluates Byte to a True or False value, and represents it as Yes or No. | |
11 (1027) | Word | SMALLINT | 2 | VMS Word Integer PIC S9(X1) COMP where X1 is between 1 and 4. | Word Integer (2 bytes) |
12 (1022) | Word -> Float | REAL | 4 | VMS Word Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 1 and 4. | Word Integer with an implied decimal place (2 bytes). |
13 (1028) | Longword | INTEGER | 4 | VMS Longword Integer PIC S9(X1) COMP where X1 is between 5 and 9. | Longword Integer (4 bytes) |
14 (1023) | Longword -> Double | DOUBLE | 8 | 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). |
15 (1029) | Quadword -> Char | VARCHAR | 20 | VMS Quadword Integer PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. | Quadword Integer (8 bytes) converts to a SQL String. |
16 (1024) | Quadword -> Char (DP) | VARCHAR | 20 | 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. |
17 | Text -> Integer | INTEGER | 4 | ||
18 | Text -> Double | DOUBLE | 8 | ||
19 | Text (Formatted) -> Double | DOUBLE | 8 | ||
20 | Zoned Numeric -> Double | DOUBLE | 8 | ||
21 | Zoned Numeric -> Integer | LONG | 4 | ||
22 (1014 with fraction > 0) | Packed Decimal -> (Double) | DOUBLE | 8 | VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 | Packed Decimal (1-255 bytes) converts to a double precision floating point. |
23 (1014 with fraction = 0) | Packed Decimal -> (Integer) | LONG | 4 | VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 | Packed Decimal (1-255 bytes) converts to a long. |
24 (1011 with fraction > 0) | Signed Overpunch -> Double | DOUBLE | 8 | VMS Numeric String left overpunched sign | Signed Overpunch (1-255 digits) converts to a double precision floating point. |
25 (1011 with fraction = 0) | Signed Overpunch -> Integer | LONG | 4 | VMS Numeric String left overpunched sign | Signed Overpunch (1-255 digits) converts to a long |
26 | (TXT) VMS Date/Time | VARCHAR | 23 | ||
27 (1002) | VMS Date | DATE | 6 | Maxcim Date | VMS Binary Date/Time (8 Bytes) converts to an ODBC Date. |
28 | VMS Time | TIME | 6 | VMS Binary Date/Time (8 Bytes) converts to an ODBC Time. | |
29 | VMS Date/Time | TIMESTAMP | 16 | VMS Binary Date/Time (8 Bytes) converts to an ODBC Timestamp. | |
30 (1052) | Reverse VMS Date | DATE | 6 | Maxcim Date | VMS Binary Date/Time (8 Bytes) converts to an ODBC Date. All bytes are stored in reverse order. |
31 (1053) | Reverse VMS Time | TIME | 6 | VMS Binary Date/Time (8 bytes) converts to an ODBC Time. All bytes are stored in reverse order. | |
32 (1054) | Reverse VMS Date/Time | TIMESTAMP | 16 | VMS Binary Date/Time (8 bytes) converts to an ODBC Timestamp. All bytes are stored in reverse order. | |
33 (1040) | Cognos PHDate | DATE | 6 | Cognos Powerhouse Date (2 bytes) converts to an ODBC Date. | |
34 (1041) | Cognos JDate | DATE | 6 | Cognos Powerhouse Julian Date (2 Bytes) converts to an ODBC Date | |
35 | Binary | BINARY | -1 | Maxcim RFA Maxcim Byte Array | The binary field is not converted. It provides access to raw, unaltered data in an RMS file. |
36 | Binary (Text) | CHAR | -2 | Each byte of data is returned as a 2-character hexadecimal representation of the original byte of data. | |
37 | Basic Plus Single | REAL | 4 | Basic Plus Single | The Basic Plus Single data type is identical to the Single data type, with all bytes in reverse order. |
38 | Basic Plus Double | DOUBLE | 8 | Basic Plus Double | The Basic Plus Double Datatype is identical to the Double Datatype, with all bytes in reverse order. |
39 | Basic Plus Word | SMALLINT | 2 | Basic Plus Word Integer | The Basic Plus Word Integer data type is identical to the Word Integer data type, with all bytes in reverse order. |
40 | Basic Plus Long | INTEGER | 4 | ||
41 (1042) | Text Date (DDMMYY) | DATE | 6 | Text Date in the specified format. Handles years between 1900 and 1999. | |
42 (1043) | Text Date (DDMMYYYY) | DATE | 6 | Text Date in the specified format. |