C-ISAM, DISAM, Micro Focus Data Types

Import Code | C-ISAM, DISAM, and Micro Focus Equivalent | CONNX Data Type | Length | Description
307 |  | 4C Date | 4 | Date in the form of days since 12/31/1799 converts to SQL Date
421 |  | Adabas Natural Timestamp -> | 7 |
36 | CHAR | BINARY (TEXT) (C-ISAM CHARTYPE filled with binary data) | -1 | Binary data.
280 |  | CISAM DIBOL Date (5 bytes) | 5 |
251 |  | CISAM Packed Decimal | 1-255 | Converts to a double precision floating point.
274 |  | CISAM Packed Decimal 1 |  | COBOL packed decimal data type.
275 |  | CISAM Packed Decimal 2 |  | Native CISAM data type for very large decimal numbers that will not fit into a double.
326 |  | CISAM Zoned Numeric -> Decimal | 1-17 char | p-y overpunch character to SQL Decimal
278 |  | CISAM Zoned Numeric -> Double | 1-19 | Converts to a double precision floating point.
279 |  | CISAM Zoned Numeric -> Integer | 1-19 | Converts to a long.
272 | DOUBLE | DOUBLE IEEE 8 BYTE | 8 | For CISAM DOUBLE on non-RISC machines.
273 | DOUBLE | DOUBLE IEEE 8 BYTE (BE) | 8 | For CISAM DOUBLE on RISC machines. (Unix only)
270 | FLOAT | FLOAT IEEE 4 Bytes | 4 | For CISAM FLOAT on non-RISC machines.
271 | FLOAT | FLOAT IEEE 4 Bytes (Big Endian) | 4 | For CISAM FLOAT on RISC machines. (Unix only)
308 |  | Gestepargne Date | 1 |
433 |  | HCHD Serial Date | -1 |
13 |  | LONGWORD | 4 |
| LONG | LONGWORD 4 Bytes (Big Endian) | 4 | For CISAM LONGTYPE.
424 |  | Opus Date | 6 |
425 |  | Opus Date Packed | 3 |
432 |  | Opus Unsigned Packed -> Decimal | -1 |
284 |  | Quadword (BE) -> Char | 8 |
285 |  | Quadword (BE) -> Chr(DP) | 8 |
327 |  | Quadword Decimal (BE) | 8 |
288 |  | Quadword Double (BE) | 8 |
1 |  | Text (Right Space Padded) | -1 |
399 | CHAR | TEXT DATE (DD) | 2 | For DD, if DD = 30, the SQL Date would be January 30, 2003. The year returned is the current year. The month is always January.
41 | CHAR | TEXT DATE (DDMMYY) | 6 | TEXT DATE in the specified format. Handles years between 1900 and 1999.
42 | CHAR | TEXT DATE (DDMMYYYY) | 8 | TEXT DATE in the specified format.
398 | CHAR | TEXT DATE (MM) | 2 | For MM, if MM was 11, the SQL Date would be November 1, 2003. The year returned is the current year. The day of the month is always one (1).
45 | CHAR | TEXT DATE (MMDDYY) | 6 | TEXT DATE in the specified format. Handles years between 1900 and 1999.
46 | CHAR | TEXT DATE (MMDDYYYY) | 8 | TEXT DATE in the specified format.
394 | DATE | TEXT DATE (MMYYYY) | 6 | For MMYYYY , if MMYYYY was 032002, the SQL date would be March 1, 2003. The day of the month is always one (1).
43 | CHAR | TEXT DATE (YYMMDD) | 6 | TEXT DATE in the specified format. Handles years between 1900 and 1999.
396 | DATE | TEXT DATE (YYYY) | 4 | For YYYY, if YYYY was 2004, the SQL Date would be January 1, 2004. The day of the month is always one (1). The month is always January.
392 | DATE | TEXT DATE (YYYYMM) | 6 | For YYYYMM , if YYYYMM was 200203, the SQL date would be March 1, 2003. The day of the month is always one (1).
44 | CHAR | TEXT DATE (YYYYMMDD) | 8 | TEXT DATE in the specified format.
59 | CHAR | TEXT DATE 2000 (DDMMYY) | 6 | TEXT DATE in the specified format. Handles years between 1941 and 2040.
60 | CHAR | TEXT DATE 2000 (MMDDYY) | 6 | TEXT DATE in the specified format. Handles years between 1941 and 2040.
395 | DATE | TEXT DATE 2000 (MMYY) | 4 | For MMYY , if MMYY was 0403, the SQL date would be April 1, 2003. The day of the month is always one (1). For MMYY , if MMYY was 0423, the SQL date would be April 1, 1923. The day of the month is always one (1). The break Year = 20. (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)
397 | DATE | TEXT DATE 2000 (YY) | 2 | For YY, if YY was 04, the SQL Date would be January 1, 2004. The day of the month is always one. The month is always January. For YY, if YY was 34, the SQL Date would be January 1, 1934. The day of the month is always one (1). The month is always January. The break Year = 20. (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)
393 | DATE | TEXT DATE 2000 (YYMM) | 4 | For YYMM , if YYMM was 0304, the SQL date would be April 1, 2003. The day of the month is always one (1). For YYMM , if YYMM was 2304, the SQL date would be April 1, 1923. The day of the month is always one (1). The break Year = 20. (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)
61 | CHAR | TEXT DATE 2000 (YYMMDD) | 6 | TEXT DATE in the specified format. Handles years between 1941 and 2040.
292 |  | Unsigned Long 4 bytes (BE) | 4 |
329 |  | Unsigned Quadword (BE) -> Dec | 8 |
295 |  | Unsigned Quadword (BE) -> Integer | 8 |
299 |  | Unsigned Quadword Double (BE) | 8 |
331 |  | Unsigned VarLen Int(BE) -> Dec | -1 |
297 |  | Unsigned VarLen Int (BE) -> Char | -1 |
298 |  | Unsigned VarLen Int(BE) -> Chr(DP) | -1 |
300 |  | Unsigned Var Length Int Db (BE) | -1 |
291 |  | Unsigned Word 2 bytes (BE) | 2 |
286 |  | VarLen Int (BE) -> Char | -1 |
287 |  | VarLen Int (BE) -> Chr(DP) |  |
289 |  | VarLen Int (BE) -> Double | -1 |
330 |  | VarLen Int (BE) -> Decimal | -1 |
262 |  | Word (BE) | 2 |
180 | INT | Word 2 Bytes (Big Endian) | 2 | CISAM Word data type for reversed bytes.
350 |  | Word Big Endian Date (2 bytes) | 6 | CISAM Date, Big Endian number of days since 1/1/1900
351 |  | Word Big Endian Time (4 bytes) | 6 | CISAM Time, Big Endian number of seconds since midnight
352 |  | Word Big Endian Timestamp | 16 | CISAM Timestamp, Big Endian number of seconds since 1/1/1970 00:00:00