CONNX Data Integration Suite 14.8.0 | Reference Guide | Data Types | Non-Relational Databases | CONNX Data Types | TXT to Longword - Double
 
TXT to Longword - Double
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 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
where X1+X2 is between 5 and 9.
Longword Integer with an implied decimal place (4 bytes).
Longword JDate (BE)
437
Date
4