SDF3 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 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)
Width controls the maximum number of digits that can be stored in the field. Precision controls the precision of the data by specifying the number of digits to the right of the decimal. 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 name of the default index attribute that is added to the feature type if no user attribute is specified with an IDENTITY index type. Attributes with an IDENTITY index type must uniquely identify the feature within the feature type: features with non-unique values for IDENTITY attributes cannot be inserted into the output SDF3 file. If multiple attributes are declared with an IDENTITY index type, then those multiple attributes form a composite identity key. |