Data types allowed in a fixed format
You can use the following data types when you are preparing
a fixed format.
| Data type | Description |
|---|---|
| Chars | ASCII format data |
| Short Unsigned Short Integer Unsigned Integer Long Integer Unsigned Long Float Double | The Machines description specifies the number of bytes required in fixed format for integers and floating-point values (see The Machines window.) When you select one of these data types, iploadsets the number of bytes. |
| Date | Date string |
| UNIX™ Date | A long integer interpreted as the system date from a UNIX system |
| Blob Length | The number of bytes of BYTE and TEXT (binary large object) that follow this record |
| Blob File | A file that contains BYTE and TEXT data |
| BLOB and CLOB | A file that contains smart large object (BLOB or CLOB) data |
| Simple LO Length | The number of bytes of simple large object data (BYTE and TEXT data) that follow this record |
| Simple LO File | The name of a file that contains a Simple LO data (BYTE and TEXT data) |
| INT8 | An eight-byte integer type |
| SERIAL8 | An eight-byte serial column |
| BIGINT | An ASCII character string or an eight-byte integer type |
| BIGSERIAL | An ASCII character string or an eight-byte integer type |
| Ext Type String | The ASCII representation of an extended data type (Ext Type) value |
| Ext Type String Length | The length of an ASCII Ext Type value. The Ext Type value follows at the end of the input/output record. Use Ext Type String Length data type if you have data that contains null UDT values. |
| Ext Type Binary | The binary representation of an Ext Type value |
| Ext Type Binary Length | The length of the binary representation of an Ext Type value. The binary value follows at the end of the input/output record. Use Ext Type Binary Length data type if you have data that contains null UDT values. |
The HPL supports several data types under the Ext Type
mechanism. As a result, the specific names of these data types do
not appear in the data-type selection list. For the following data
types, choose the appropriate Ext Type data type:
- INT8
- LVARCHAR
- SERIAL8
- BLOB
- BOOLEAN
- CLOB
- Collection data types
- Distinct data type
- Opaque data types
- Row types