For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
| Name | The name of the field to be written. |
| Type |
Choose one of the following field types.  bigint
This type is used to represent 64-bit signed integers, from ‑2^63+1 to 2^63-1 bigserial
This type is used to represent unsigned integers from 1 to 2^63-1. A table can have at most one BIGSERIAL column. Existing BIGSERIAL values cannot be updated. BIGSERIAL columns cannot hold null values. binary18
This type is used to represent fixed-length binary data up to a length of 18 bytes. The BINARY18 data type is only available with the Informix Binary DataBlade extension. binaryvar
This type is used to represent variable length binary data up to a length of 255 bytes. The BINARYVAR data type is only available with the Informix Binary DataBlade extension. blob
This type is used to store binary data of up to 4 terabytes. boolean
This type is used to store the logical values true or false. byte
This type is used to represent variable length binary data up to a length of 2 gigabytes. char
This type is used to represent fixed-length character data up to a length of 32,767 bytes. clob
This type is used to store character data up to a length of 4 terabytes. date
This type is used to represent date data from January 1, 0001 to December 31, 9999. datetime
This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with variable fractional second precision. decimal
This type is used to represent fixed precision and scale numeric data from 1-10^31 to 10^31-1. float
This type is used to represent 64-bit floating precision numbers. integer
This type is used to represent 32-bit signed integers from ‑2^31+1 to 2^31-1. json
This type is used to represent JSON documents up to a length of 32 kilobytes in the form of plain text. The JSON data type is only available in Informix version 12.10 or newer. lvarchar
This type is used to represent variable-length character data up to a length of 32,739 bytes. money
This type is used to represent fixed precision monetary values up to 32 significant digits. nchar
This type is used to represent fixed-length character data up to a length of 32,767 bytes. nvarchar
This type is used to represent varying length character data up to a length of 255 bytes. serial
This type is used to represent unsigned integers from 1 to 2^31-1. A table can have at most one SERIAL column. Existing SERIAL values cannot be updated. SERIAL columns cannot hold null values. This type is used to represent 32-bit floating precision numbers. smallint
This type is used to represent 16-bit signed integers from -2^15+1 to 2^15-1. text
This type is used to represent variable-length character data up to a length of 2 gigabytes. varchar
This type is used to represent variable-length character data up to a length of 255 bytes. |
| Index |
The types of indexes and constraints to create for the column, if the table is created. Each index and constraint contains only one column. The valid values for the column type are listed below: PrimaryKey: A primary key with non-nullable and unique constraints. Unique: An index with a unique constraint. NotNull: A non-nullable constraint. |