The following tables contain the available data types for databases supported by CONNX. Several of the data types have more than one import code, supplied for compatibility with earlier versions of CONNX.
CONNX Data Types
CONNX Data Type |
Import Code |
SQL Data Type |
Length |
VMS Equivalent Data Types |
Description |
---|---|---|---|---|---|
(TXT) VMS Date/Time |
26 |
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. |
24 bit Pascal Integer |
99 |
INTEGER |
3 |
|
24-bit Pascal Integer 3 bytes. |
4C Date |
307 |
DATE |
4 |
|
Date in the form of days since 12/31/1799 converts to SQL Date |
Access Currency |
252 |
CURRENCY |
-1 |
|
|
Adabas Natural Date |
403 |
DATE |
4 |
|
|
Adabas Natural Time |
404 |
TIME |
7 |
|
|
Adabas Packed Decimal -> Integer |
421 |
LONG |
-1 |
|
|
Adabas Packed Decimal -> Decimal |
422 |
DECIMAL |
-1 |
|
|
Adabas Natural Timestam -> Date |
423 |
DATE |
7 |
|
|
Adabas Text (LA VarChar) |
441 |
VarChar |
-1 |
|
|
Adabas Text (L4 VarChar) |
442 |
VarChar |
-1 |
|
|
ADL Date |
121 |
DATE |
4 |
|
Custom Data Type for ADL |
ADL GL Number |
122 |
DOUBLE |
4 |
|
Custom Data Type for ADL |
ADL Math |
119 |
DOUBLE |
1-20 |
|
Custom Data Type for ADL |
ADL MMIS Number |
120 |
CHAR |
23 |
|
Custom Data Type for ADL |
ADL Old Math |
125 |
VARCHAR |
1-8 |
|
Custom Data Type for ADL |
ADL Type Code |
123 |
VARCHAR |
2 |
|
Custom Data Type for ADL |
ADL Zip Code |
124 |
LONG |
4 |
|
Custom Data Type for ADL |
Adonix Date |
383 |
DATE |
6 |
|
Customer-specific Julian date offset from 12/31/1599 |
Allport Julian Date (2 byte) |
155 |
DATE |
2 |
|
Custom Data Type for Allport |
Allport Julian Date (4 byte) |
116 |
DATE |
4 |
|
Allport Julian Date |
Allport Julian Date String |
356 |
DATE |
5 |
|
Character string Julian (jumeric) date offset from 1/1/1970 |
Allport Time |
117 |
TIME |
4 |
|
Allport Time |
ANSI/ISO SQL Timestamp |
434 |
Timestamp |
-1 |
|
|
Astrazeneca Interval |
277 |
DATE |
8 |
|
Customer-specific data type |
Basic Plus Double |
38 |
DOUBLE |
8 |
Basic Plus Double |
The Basic Plus Double Datatype is identical to the Double Datatype, with all bytes in reverse order. |
Basic Plus Long |
40 |
INTEGER |
4 |
|
|
Basic Plus Single |
37 |
REAL |
4 |
Basic Plus Single |
The Basic Plus Single data type is identical to the Single data type, with all bytes in reverse order. |
Basic Plus Word |
39 |
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. |
Binary |
35 |
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) |
36 |
CHAR |
1-32000 |
|
Each byte of data is returned as a 2-character hexadecimal representation of the original byte of data. |
BMS Date |
78 |
DATE |
3 |
|
3-byte Date for BMS. |
BMS Reverse Date |
79 |
DATE |
3 |
|
3-byte Reverse Date for BMS. |
BOSS Date CCYY |
221 |
DATE |
6 |
|
Custom 6-byte, Y2K-compliant date for BOSS. |
BOSS Julian CCYY |
223 |
DATE |
5 |
|
Custom 5-byte, Y2K-compliant Julian date for BOSS. |
BOSS Julian YYYYJJJ |
240 |
DATE |
7 |
|
Custom 7-byte, Y2K-compliant Julian date for BOSS. |
BOSS Year CCYY |
222 |
SMALLINT |
4 |
|
Custom 4-byte, Y2K-compliant year for BOSS. |
Byte -> Float |
8 |
REAL |
1 |
VMS Byte Integer with implied decimal. |
Byte Integer with an implied decimal place (1 byte). |
Byte |
7 |
TINYINT |
1 |
|
|
Byte Bit (1/0) |
9 (1001 for backward compatibility) |
BIT |
1 |
|
Evaluates Byte to a True or False value, and represents it as a bit. |
Byte Bit #0 (2^0) |
83 |
BIT |
1 |
|
This represents bit #1 (2^0) from the byte. |
Byte Bit #1 (2^1) |
84 |
BIT |
1 |
|
This represents bit #2 (2^1) from the byte. |
Byte Bit #2 (2^2) |
85 |
BIT |
1 |
|
This represents bit #3 (2^2) from the byte. |
Byte Bit #3 (2^3) |
86 |
BIT |
1 |
|
This represents bit #4 (2^3) from the byte. |
Byte Bit #4 (2^4) |
87 |
BIT |
1 |
|
This represents bit #5 (2^4) from the byte. |
Byte Bit #5 (2^5) |
88 |
BIT |
1 |
|
This represents bit #6 (2^5) from the byte. |
Byte Bit #6 (2^6) |
89 |
BIT |
1 |
|
This represents bit #7 (2^6) from the byte. |
Byte Bit #7 (2^7) |
90 |
BIT |
1 |
|
This represents bit #8 (2^7) from the byte. |
Byte Bit Text(Yes/No) |
10 |
CHAR |
3 |
|
Evaluates Byte to a True or False value, and represents it as Yes or No. |
Byte Numeric -> Decimal |
309 |
DECIMAL |
1 |
|
Single signed byte value converts to a SQL Decimal |
CA Bit Flag |
306 |
INTEGER |
1 |
|
Customer-specific (1 byte of individual bit flags) |
CA Window |
305 |
VarCHAR |
150 |
|
Customer-specific (up to 5 lines of 30 chars each) |
CISAM DIBOL Date (5 bytes) |
280 |
DATE |
5 |
|
|
CISAM Zoned Numeric -> Double |
278 |
DOUBLE |
-1 |
|
|
CISAM Zoned Numeric -> Integer |
279 |
LONG |
-1 |
|
|
Coda Year |
76 |
SMALLINT |
2 |
|
Word, a year is represented in a number offset from the year 1900. A value of 50 would represent 1950, and a value of 103 would represent the year 2003. |
Cognos JDate |
43 (1041 for backward compatibility) |
DATE |
2 |
|
Cognos Powerhouse Julian Date (2 Bytes) converts to an ODBC Date |
Cognos PHDate |
33 (1040 for backward compatibility) |
DATE |
2 |
|
Cognos Powerhouse Date (2 bytes) converts to an ODBC Date. |
Cognos PHDate 2000 |
239 |
DATE |
2 |
|
Cognos Powerhouse Date (2 bytes) converts to an ODBC Date. |
Comment Prefix |
269 |
VARCHAR |
-1 |
|
|
Compressed String |
243 |
VARCHAR |
8 |
|
CONNX removes all spaces from the text string. |
Compufast Text Date (YYYYMMDD) |
435 |
Date |
10 |
|
|
CS Comment |
440 |
VarChar |
-1 |
|
|
DAI History Date |
106 |
DATE |
8 |
|
Date in YYMMDD format subtracted from 999999. Site-specific. |
DAI History Period |
109 |
SMALLINT |
2 |
|
Period in PP format subtracted from 99. Site-specific. |
DAI History Time |
107 |
DATE |
6 |
|
Time in HHMMSS format subtracted from 999999. |
DAI History Year |
108 |
SMALLINT |
4 |
|
Year in YYYY format subtracted from 9999. |
Decimal (Formatted with DP) |
238 |
DECIMAL |
1-255 |
|
Number stored as text with decimal point physically stored in field. |
DIBOL Date (5 bytes) |
170 |
DATE |
5 |
|
|
Double Prec float (mainframe) |
264 |
SQL_DOUBLE |
2 |
|
|
Double Text Formatted |
19 |
DOUBLE |
8 |
|
|
EDS Date YYMMDD |
242 |
DATE |
6 |
|
Site-specific |
EDS Julian Date YYDD |
241 |
DATE |
5 |
|
Site-specific |
Encapsulated Date (cyMMDD) |
388 |
SQL_DATE |
6 |
|
Byte 0 -> binary number representing the most significant two digits of a four digit year. Byte 1 -> binary number representing the least significant two digits of a four digit year. Thus, if given the first two bytes values of 20, 03, the year for this date are 2003. Bytes 2 & 3 are the numeric characters representing the month of the year. Bytes 4 & 5 are the numeric characters representing the day of the month. Thus a value of 0x010131313131 is a date of November (month 11) 11 (day 11) in the year 101. |
Fairfield Text Date (DD) |
403 |
DATE |
2 |
|
For DD, if DD were 20, then the SQL Date would be January 20, 1900. The year returned in always 1900. The month returned is always January. |
Fairfield Text Date (MM) |
402 |
DATE |
2 |
|
For MM, if MM were 11, then the SQL Date would be November 1, 1900. The year returned in always 1900. The day returned is always 1. |
Fairfield Text Date (MMDD) |
401 |
DATE |
4 |
|
For MMDD, if MM were 11 and DD were 20, then the SQL Date would be November 20, 1900. The year returned is always 1900. |
Float IEEE 4-byte |
270 |
REAL |
4 |
|
|
Float IEEE 4-byte (BE) |
271 |
REAL |
4 |
|
|
Globally Unique ID (GUID) |
436 |
Char |
16 |
|
|
Julian Timestamp |
441 |
SQL_TIMESTAMP |
16 |
|
|
KCS Compressed Integer |
161 |
INTEGER |
|
|
Site-specific. |
KCS Date (3 bytes) |
167 |
DATE |
3 |
|
Site-specific. |
KCS Phone |
162 |
CHAR |
5 |
|
Site-specific. |
KCS Time (2 byte) |
164 |
TIME |
2 |
|
Site-specific. |
KCS Time (3 bytes) |
165 |
TIME |
3 |
|
Site-specific. |
KCS Zip Code |
163 |
CHAR |
5 |
|
Site-specific. |
Left Separate -> Decimal |
319 |
DECIMAL |
1-17 char |
|
Character to SQL Decimal with leading sign |
Left Separate -> Double |
110 |
DOUBLE |
1-20 |
Left Separate |
Left Separate Double |
Left Separate -> Integer |
111 |
LONG |
1-20 |
Left Separate |
Left Separate Integer |
Long Date (DDMMYY) |
47 (1035 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
Long Date (DDMMYYYY) |
48 (1036 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. |
Long Date (MMDDYY) |
51 (1048 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
Long Date (MMDDYYYY) |
52 (1049 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. |
Long Date (YYMMDD) |
49 (1037 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
Long Date (YYYYMMDD) |
50 (1038 for backward compatibility.) |
DATE |
4 |
|
Longword Date in the specified format. |
Long Date 2000 (DDMMYY) |
62 |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
Long Date 2000 (MMDDYY) |
64 |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
Long Date 2000 (YYMMDD) |
63 |
DATE |
4 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
Longword |
13 |
INTEGER |
4 |
VMS Longword Integer PICS9(X1) COMP where X1 is between 5 and 9. |
Longword Integer (4 bytes) |
Longword (BE) |
263 |
SQL_INTEGER |
4 |
|
|
Longword (BE) -> Double |
266 |
DOUBLE |
4 |
|
|
Longword (BE) |
263 |
SQL_INTEGER |
4 |
|
|
Longword Currency |
71 (1032 for backward compatibility.) |
CURRENCY |
4 |
|
|
Longword -> Decimal |
311 |
DECIMAL |
1-17 char |
|
Character to SQL Decimal with leading sign |
Longword Decimal Big Endian |
267 |
DOUBLE |
4 |
|
|
Longword -> Double |
14 (1023 for backward compatibility.) |
DOUBLE |
4 |
VMS Longword Integer with implied decimal PIC S9(X1)V9(X2) COMP |
Longword Integer with an implied decimal place (4 bytes). |
Longword JDate (BE) |
437 |
Date |
4 |
|
|