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
where X1+X2 is between 5 and 9.

Longword Integer with an implied decimal place (4 bytes).

Longword JDate (BE)

437

Date

4