IBM Informix Non-Spatial User Attributes

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 attribute name.
Type

This format supports the following types.

blob

This type is used to store binary data of up to 4 terabytes.

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.

character varying

This type stores a string of letters, digits, and symbols of varying length, where m is the maximum size of the column (in bytes) and r is the minimum number of bytes reserved for that column.

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.

See Standard FME Date/Time Format.

datetime

This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with variable fractional second precision.

See Standard FME Date/Time Format.

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.

int8

This type stores whole numbers that can range in value from
–9,223,372,036,854,775,807 to 9,223,372,036,854,775,807 [or -(263-1) to 263-1], for 18 or 19 digits of precision.

integer

This type is used to represent 32-bit signed integers from ‑2^31+1 to 2^31-1.

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.

smallfloat

This type stores single-precision floating-point numbers with approximately nine significant digits.

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.