226

Text (Left Space Padded)

CHAR

-1

227

Text Left Space Pad -> Int

INTEGER

4

228

Text Left Space Pad -> Dbl

DOUBLE

8

TextMaxcim Yes/No

Alphanumeric and symbols. (1-30000 chars); same as Text but with left space padding.

229

Unsigned Pk Date (DDMMYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

230

Unsigned Pk Date (DDMMYYYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

231

Unsigned Pk Date (YYMMDD)

DATE

6

Unsigned Packed Decimal Date in the specific format.

232

Unsigned Pk Date (YYYYMMDD)

DATE

6

Unsigned Packed Decimal Date in the specific format.

233

Unsigned Pk Date (MMDDYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

234

Unsigned Pk Date (MMDDYYYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

235

Unsigned Pk Date 2000 (DDMMYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

236

Unsigned Pk Date 2000 (YYMMDD)

DATE

6

Unsigned Packed Decimal Date in the specific format.

237

Unsigned Pk Date 2000 (MMDDYY)

DATE

6

Unsigned Packed Decimal Date in the specific format.

238

Decimal (Formatted with DP)

DECIMAL

-1

239

Cognos PHDate 2000

DATE

6

Cognos Powerhouse Date (2 bytes) converts to an ODBC Date.

240

BOSS Julian YYYYJJJ

DATE

6

Site-specific, 5-byte, Y2K-compliant Julian date.

241

EDS Julian Date YYDDD

DATE

6

Site-specific.

242

EDS Date YYMMDD

DATE

6

Site-specific.

243

Compressed String

VARCHAR

-1

All spaces removed from the text field.

244

Reverse Text Date YYYYMMDD

DATE

6

Subtracts 10000000 from the date, stored physically as a character field, yielding strings that, if sorted, result in dates in descending order.

245

Reverse Long Date YYYYMMDD

DATE

6

Subtracts 10000000 from the date, stored physically as a Long, yielding strings that, if sorted, result in dates in descending order.

246

Text Null Terminated (I)

VARCHAR

-1

247

POISE Record Number

INTEGER

4

A special data type used only in the record field of any POISE key file.

248

POISE Validate Code

VARCHAR

-8

none

A short code descriptor is populated in the CDD comment field.

When the field is displayed using CONNX. the code descriptor prefixes the data value.

249

Pk Centry Date (CYYMMDD)

DATE

6

250

Unsigned Quadword

BIGINT

8

251

CISAM Packed Decimal

DECIMAL

-9

252

Access Currency

CURRENCY

21

253

Text (Nullable) -> Integer

INTEGER

4

254

Text (Nullable) -> Double

DOUBLE

8

255

Text DB2 (Right Space Padded)

CHAR

-1

256

Text DB2 (Null Terminated)

VARCHAR

-1

257

POISE Text Date 2000 (MMDDYY)

DATE

6

POISE Text Date in the specified format. Handles years between 1941 and 2040.

258

POISE Text Date (MMDDYYYY)

DATE

6

POISE Text Date in the specified format.

259

POISE Double (Right Padded)

DOUBLE

8

ASCII double left space padded with explicit decimal point and sign. Used to convert the data type in POISE RMS key field(s).

260

POISE Julian Date

DATE

6

2 byte, Julian format (1=01/01/1970)

261

POISE Time

TIME

6

2-byte field contains minutes after midnight.

262

Word (big endian)

SQL_SMALLINT

2

263

Longword

SQL_INTEGER

4

264

Single Prec float (Mainframe)

REAL

4

265

Double Prec float (Mainframe)

DOUBLE

8