The formatitem table in the onpload database
The formatitem table defines the data-file records. Each field of a data file is described by an entry in this table. Use the Records Format window to prepare the record formats.
Possible
values for the ftype column lists
the possible values for the ftype column. For more information,
see A completed Fixed-Format
Definition window with an open selection list.
| Column | Type | Description |
|---|---|---|
| formid | INTEGER | Record format identifier (foreign key to the formats table) |
| seq | INTEGER | Item sequence number for internal organization |
| fname | CHAR(128) | Name of record field |
| ftype | INTEGER | A number that indicates the type of data in the field |
| bytes | INTEGER | Number of bytes in field |
| decimals | INTEGER | Number of decimal values to format when converting to ASCII |
| offset | INTEGER | Offset in record image where field starts |
| qual | INTEGER | HCL Informix® DATETIME/INTERVAL qualifier |
| picture | CHAR(15) | COBOL picture definition |
| Value for ftype | Type of data |
|---|---|
| 1 | Character (fixed and delimited) |
| 2 | Date |
| 3 | Short integer |
| 4 | Integer |
| 5 | Long Integer |
| 6 | Floating-point vale |
| 7 | Double floating-point value |
| 8 | Unsigned short integer |
| 9 | Unsigned integer |
| 10 | Unsigned long integer |
| 11 | UNIX™ date |
| 18 | Packed Decimal |
| 19 | Zoned decimal |
| 20 | Comp-1 |
| 21 | Comp-2 |
| 22 | Comp-3 |
| 23 | Comp-4 |
| 24 | Comp-5 |
| 25 | Comp-6 |
| 26 | Comp-X |
| 27 | Comp-N |
| 28 | Character (COBOL) |
| 34 | Blob Length |
| 35 | Blob File |
| 36 | Blob HexASCII |
| 37 | Blob Text |
| 39 | INT8 |
| 40 | SERIAL8 |
| 41 | BOOLEAN |
| 42 | Extended Type String |
| 43 | Extended Type HexASCII |
| 44 | Extended Type Binary |
| 45 | Extended Type StringLength |
| 46 | Extended Type BinaryLength |
| 49 | BIGINT |
| 50 | BIGSERIAL |
| 51 | INT64 (64-bit integer) |