JDBC (Java Database Connectivity) Writer Feature Type: 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 section describes the attribute types for a table.

Not all JDBC attribute types are implemented by all databases. Using an unsupported type will result in errors during table creation. In addition, databases often implement types in slightly different ways, so the descriptions below may not be accurate in all cases.

Closedbigint

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

Closedinteger

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

Closedsmallint

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

Closedtinyint

This type is used to represent 8-bit integers that may be signed or unsigned.

Closedbit

This type is used to represent an integer with a value of 1 (True) or 0 (False).

Closeddecimal

This type is used to represent fixed precision and scale numeric data with at least the specified precision.

Closednumeric

This type is used to represent fixed precision and scale numeric data with exactly the specified precision.

Closeddouble

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

Closedreal

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

Closeddate

This type is used to represent dates.

See Standard FME Date/Time Format.

Closedtime

This type is used to represent times.

See Standard FME Date/Time Format.

Closedtimestamp

This type is used to represent date and time data.

See Standard FME Date/Time Format.

Closedchar

This type is used to represent fixed-length character data.

Closedvarchar

This type is used to represent variable-length character data.

Closedclob

This type is used to represent large amounts of variable-length character data.

Closednchar

This type is used to represent fixed-length international character data.

Closednvarchar

This type is used to represent variable-length international character data.

Closednclob

This type is used to represent large amounts of variable-length international character data.

Closedbinary

This type is used to represent fixed-length binary data.

Closedvarbinary

This type is used to represent variable-length binary data.

Closedblob

This type is used to represent large amounts of variable-length binary data.
Index

The type of index or constraint to create for the column. Indexes and constraints are only created if the table is created.

The valid values for the column type are listed below:

PrimaryKey: Create a Primary Key index on the column.

Unique: Only one of each non-null value is allowed in the column.

NotNull: Nulls are not allowed in the column.

UniqueNotNull: Only one of each value is allowed in the column. Nulls are not allowed.