IBM DB2 Non-Spatial (JDBC) Writer: User Attributes
For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes
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. 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. dbclob
This type is used to represent variable-length double-byte character data up to a length of 1,073,741,823 characters. 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. graphic
This type is used to represent fixed-length double-byte character data up to a length of 127 characters. Requires the database to be UTF-8 encoded. 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. long_vargraphic
This deprecated type is used to represent variable-length double-byte character data up to a length of 16,350 characters. Requires the database to be UTF-8 encoded. Use vargraphic or dbclob 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. timestamp
This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with variable precision. 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. vargraphic
This type is used to represent variable length double-byte character data up to a length of about 16,336 characters depending on the page size of the table space and the DB2 hosting platform. Requires the database to be UTF-8 encoded. 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. |