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 feature type to be written. |
| Type |
The type of the data property. The valid values are listed below:  boolean
Represents logical Boolean values (true/false). datetime
Temporal field composed of year, month, day, hours, minutes, and seconds; accurate to three decimal places (microseconds). Datetime values are returned in the Standard FME Date/Time Format. decimal(width, precision)
Floating point number with variable precision and subsequently variable range. The width parameter controls the maximum number of digits that can be stored in the field. The precision parameter controls the precision of the data by specifying the number of digits to the right of the decimal. The precision should always be strictly less than the width. The width value counts special characters including decimal separators but not minus signs, leading zeros, trailing decimal zeros, or exponent symbols and signs. Examples decimal(4,0) can hold: 1234, -1234, 1.23e+2, 12.3, 01234 but cannot hold: 12340, 1.23e+3, 12.34 The precision value is subtracted from the width before applying the rules above for whole numbers. decimal(4,2) can hold: 1.23, -1.23, -1.23e+2 but cannot hold: 12.34, -12.34, 1234 int16
Integer field containing 16-bit values in the range -32,768 to 32,767. Field size: 2 bytes int32
Integer field containing 32-bit values in the range ‑2,147,483,648 to 2,147,483,647. Field size: 4 bytes int64
Integer field containing 64-bit values in the range ‑9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. Field size: 8 bytes byte
Integer field containing 8-bit values in the range -128 to 127. Field size: 1 byte single
Floating point number with a precision of 6. Field size: 4 bytes double
Floating point number with a precision of 15. Field size: 8 bytes char(width)
Character field for storing fixed-length strings. The width parameter controls the maximum number of characters that can be stored in the field. When a character field is written, it is right-padded with space characters, or truncated to fit the width. When a character value is retrieved, any right-padded space characters are stripped away. Data is stored in the encoding of the database. blob(width)
This is similar to the char field type except that it stores raw binary data. Up to width bytes can be stored in a blob field. clob(width)
This is similar to the blob field type except that it stores textual data exactly as input. Up to width bytes can be stored in a clob field. |
|
Index |
The valid values for the column type is:
Attributes with a PrimaryKey index type must uniquely identify the feature within the feature type: features with non-unique values for PrimaryKey attributes cannot be inserted into the output SDF3 file. If multiple attributes are declared with a PrimaryKey index type, then those multiple attributes form a composite identity key. |