The following table contains the available data types for databases supported by CONNX, organized by import code number. Several of the data types have more than one import code, supplied for compatibility with earlier versions of CONNX.
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 |
Single precision floating point (4 bytes). |
6 (1017) |
VMS Double |
DOUBLE |
8 |
VMS 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 |
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 |
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 |
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. |