IBM DB2 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 name of the field to be written.
Type

This format supports the following field types:

bigint

This type is used to represent 64-bit signed integers.

blob

This type is used to represent variable length binary data up to a length of 2,147,483,647 bytes.

char

This type is used to represent fixed-length character data up to a length of about 254 bytes depending on the DB2 hosting platform.

clob

This type is used to represent variable-length character data up to a length of 2,147,483,647 bytes.

date

This type is used to represent date data from January 1, 0001 to December 31, 9999.

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.

double

This type is used to represent 64-bit floating precision numbers.

integer

This type is used to represent 32-bit signed integers.

long_varchar

This deprecated type is used to represent variable-length character data up to a length of 32,700 bytes. Use varchar or clob instead.

real

This type is used to represent 32-bit floating precision numbers.

smallint

This type is used to represent 16-bit signed integers.

time

This type is used to represent time data in the range of 00:00:00 to 24:00:00.

See Standard FME Date/Time Format.

timestamp

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

See Standard FME Date/Time Format.

varchar

This type is used to represent variable length character data up to a length of about 32,672 bytes depending on the page size of the table space and the DB2 hosting platform.

xml

This type is used to represent XML documents and fragments.

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:

NotNull: A non-nullable constraint.