266

Word (BE) -> Double

DOUBLE

8

267

Longword Decimal Big Endian

DOUBLE

8

268

Binary (Text) Reversed

CHAR

-2

269

Comment Prefix

VARCHAR

-8

270

Float IEEE 4-byte

REAL

4

271

Float IEEE 4-byte (BE)

REAL

4

272

Double IEEE 8-byte

DOUBLE

8

273

Double IEEE 8-byte (BE)

DOUBLE

8

274

CISAM Packed Decimal 1

DOUBLE

8

275

CISAM Packed Decimal 2

VARCHAR

128

276

PROIV Date

DATE

6

277

Astrazeneca Interval

VARCHAR

18

278

CISAM Zoned Numeric -> Double

DOUBLE

8

279

CISAM Zoned Numeric -> Integer

LONG

4

280

CISAM DIBOL Date (5 bytes)

DATE

6

281

Time (Text HHMM)

TIME

6

282

Time (Text HHMMSS)

TIME

6

283

Pinnacle Date

DATE

6

284

Quadword (BE) -> Char

VARCHAR

20

285

Quadword (BE) -> Char (DP)

VARCHAR

20

286

VarLen Int (BE) -> Char

CHAR

20

287

VarLen Int (BE) -> Char DP

CHAR

20

288

Quadword (BE) -> Double

DOUBLE

8

289

VarLen Int (BE) -> Double

DOUBLE

8

290

VarLen Int -> Double

DOUBLE

8

291

Unsigned Word 2 bytes (BE)

SMALLINT

2

292

Unsigned Long 4 bytes (BE)

INTEGER

4

293

Unsigned Word Decimal (BE)

DOUBLE

8

294

Unsigned Long (BE) -> Double

DOUBLE

8

295

Unsigned Quad (BE) -> Char

VARCHAR

20

296

Unsigned Quad (BE) -> Char(DP)

VARCHAR

20

297

Unsigned VarLen Int(BE)->Char

CHAR

20

298

Unsigned VarLen Int(BE)->Char(DP)

CHAR

20

299

Unsigned Quadword Double (BE)

DOUBLE

8

300

Unsigned VarLen Int (BE) -> Dbl

DOUBLE

8

301

Unsigned Byte Double

DOUBLE

8

Single unsigned byte value converts to a SQL Double

302

PostgreSQL Timestamp

TIMESTAMP

16

303

PostgreSQL Date

DATE

6

304

PostgreSQL Time

TIME

8

305

CA Window

VARCHAR

155

306

CA Bit Flag

INTEGER

4

Customer-specific (1 byte of individual bit flags)

307

4C Date

DATE

6

Date in the form of days since 12/31/1799 converts to SQL Date

308

Gestepargne Date

DATE

6

309

Byte Numeric -> Decimal

DECIMAL

5

Single signed byte value converts to a SQL Decimal

310

Word Numeric -> Decimal

DECIMAL

7

Two-byte signed value converts to a SQL Decimal

311

Longword -> Decimal

DECIMAL

12

Three-byte signed value converts to a SQL Decimal

312

Quadword -> Decimal

DECIMAL

21

Four-byte signed value converts to a SQL Decimal

313

Zoned Numeric-> Decimal

DECIMAL

-6

String of digits with sign overpunched in lowest (right) digit converts to SQL Decimal

314

Packed Decimal -> Decimal

DECIMAL

-7

Packed decimal converts to SQL Decimal

315

Signed Overpunch -> Decimal

DECIMAL

-6

Overpunched decimal converts to SQL Decimal

316

PACKED (A) Decimal -> Decimal

DECIMAL

-7

Packed decimal to SQL Decimal, value of 'A' denotes negative

317

PACKED (E) Decimal -> Decimal

DECIMAL

-7

Packed decimal to SQL Decimal, value of 'E' denotes negative

318

PACKED (F) Decimal -> Decimal

DECIMAL

-7

Packed decimal to SQL Decimal, value of 'F' denotes negative

319

Left Separate -> Decimal

DECIMAL

-10

Character to SQL Decimal with leading sign

320

Right Separate -> Decimal

DECIMAL

-10

Character to SQL Decimal with trailing sign

321

National Compressed -> Decimal

DECIMAL

-11

Customer-specific numeric to SQL Decimal

322

Flex Numeric

DECIMAL

-1

323

VarLen Integer -> Decimal

DECIMAL

-11

Binary variable length integer to SQL Decimal

324

POISE Txt (Right Pad) -> Decimal

DECIMAL

-1

Customer-specific character to SQL Decimal

325

PACKED Decimal COMP6 -> Decimal

DECIMAL

-13

Unsigned packed decimal to SQL Decimal

326

CISAM Zoned Numeric

-> Decimal

DECIMAL

-6

327

Quadword (BE) -> Decimal

DECIMAL

21

328

VarLen Int -> Decimal

DECIMAL

-11

Integer (2, 4, 8 bytes) to SQL Decimal (string) (DEPRECATED)

329

Unsigned Quadword(BE) -> Dec

DECIMAL

21

330

VarLen Int (BE) -> Decimal

DECIMAL

-11

331

Unsigned VarLen Int(BE)->Dec

DECIMAL

-12

332

Text -> Decimal

DECIMAL

-6

Character to SQL Decimal

333

Unsigned Byte -> Decimal

DECIMAL

5

Unsigned byte number to SQL Decimal

334

Unsigned Word (BE) -> Decimal

DECIMAL

7

335

Unsigned Long (BE) -> Decimal

DECIMAL

12

336

Word (BE) -> Decimal

DECIMAL

7

337

Longword (BE) -> Decimal

DECIMAL

12

338

RDB Date VMS (String)

TIMESTAMP

16

339

Mark BIB Number

LONG

4

340

Unsigned PK(F) Dt (DDMMYY)

DATE

6

Packed date DDMMYY to SQL Date

341

Unsigned PK(F) Dt (DDMMYYYY)

DATE

6

Packed date DDMMYY to SQL Date

342

Unsigned PK(F) Dt (YYMMDD)

DATE

6

Packed date YYMMDD to SQL Date

343

Unsigned PK(F) Dt (YYYYMMDD)

DATE

6

Packed date YYYYMMDD to SQL Date

344

Unsigned PK(F) Dt (MMDDYY)

DATE

6

Packed date MMDDYY to SQL Date

345

Unsigned PK(F) Dt (MMDDYYYY)

DATE

6

Packed date MMDDYYYY to SQL Date

346

Unsigned PK(F) Dt 2000(DDMMYY)

DATE

6

Packed date DDMMYY date window to SQL Date

347

Unsigned PK(F) Dt 2000(YYMMDD)

DATE

6

Packed date YYMMDD date window to SQL Date

348

Unsigned PK(F) Dt 2000(MMDDYY)

DATE

6

Packed date MMDDYY date window to SQL Date

349

CISAM Zoned Decimal

DECIMAL

-6

350

Word Big Endian Date (2 bytes)

DATE

6

351

Word Big Endian Time (4 bytes)

TIME

6

352

Word Big Endian Timestamp

TIMESTAMP

16

353

Timestamp12 (YYYYMMDDHHMM)

TIMESTAMP

16

Character Timestamp with year, month, day, hour, and minute

354

Timestamp14 (YYYYMMDDHHMMSS)

TIMESTAMP

16

Character Timestamp with year, month, day, hour, minutes, and second

355

Vector Timestamp

TIMESTAMP

16

Unsigned short of year, month, day, hour, minute, second, and 1000ths of a second

356

Allport Julian Date String

DATE

6

Character string Julian (jumeric) date offset from 1/1/1970