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