Generic (Any Format) 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:
Fixed Schema
The user attributes for this format come from the schema; they are visible in the Feature Type > User Attributes tab, but you cannot modify them.
The following table shows the attribute types that are supported by the Generic writer.
If an output format does not support a particular attribute type, the Generic writer will attempt to pick the closest supported output attribute type, if one is available; otherwise, it will report an error.
Name | The name of the field to be written. |
Type |
This format supports the following field types. boolean
Boolean fields store TRUE/FALSE data. Data read or written from and to such fields must always have a value of either true or false. buffer
Unknown length character fields store strings whose length is unknown and potentially unbounded. If the target format cannot support unbounded length fields, these will be turned into varchar(255) or char(255) fields. char(<width>)
Character fields store fixed-length strings. The width parameter controls the maximum number of characters that can be stored by the field. No padding is required for strings shorter than this width. copied
The schema type is copied from the same attribute on the reader's schema. date
Date fields store dates as character strings with the format YYYYMMDD. datetime
Datetime fields store datetimes as character strings with the format YYYYMMDDhhmmss.ss. decimal(<width>,<decimals>)
Decimal fields store single and double precision floating point values. The width parameter is the total number of characters allocated to the field, including the decimal point. The decimals parameter controls the precision of the data and is the number of digits to the right of the decimal. int16
int16 small integer fields store 16 bit signed integers and therefore have a range of -32,768 to +32,767. int32
int32 fields store 32 bit signed integers. real32
real32 fields store single precision floating point values. real64
real64 fields store double precision floating point values. varchar(<width>)
Variable length character fields store variable length strings. The width parameter controls the maximum number of characters that can be stored by the field. If the target format cannot support variable length fields, these will be turned into char(<width>) fields. |
Index |
The type of index to create for the column. If the table does not previously exist, then upon table creation, a database index of the specified type is created. The database index contains only one column. Note: A given table can contain, at most, one clustered index. The valid values for the column type are listed below: indexed: An index without constraints. indexed_not_null: An index with a non-nullable constraint. unique: An index with a unique constraint. unique_clustered: A clustered index with a unique constraint. clustered: A clustered index without constraints. clustered_not_null: A clustered index with a non-nullable constraint. not_null: A non-nullable constraint. primary_key: A primary key with non-nullable and unique constraints. |