Autodesk SQLite Spatial (FDO) Writer Feature Type Parameters
|
To access feature type parameters, click the gear icon Tip To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.
General All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry. In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type. |
Table
Specifies how features will be written into the destination table. Supported feature operations are:
- Inherit from Writer: Take the value from the writer level (do not override the value at the feature type level).
- Insert: Append rows onto the destination table using attributes on features.
- Update: Update existing table columns using attributes on features. A selection method must be specified in the Row Selection group.
- Delete: Delete existing table rows. A selection method must be specified in the Row Selection group.
More information about Writer Mode.
Specifies 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. This parameter defaults to PRIMARYINDEX.
A comma-separated list of the geometry column names for writing.
Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.
This parameter has no effect when the Writer Mode is Delete.
- No: The table will be created if it does not exist.
- Yes: The table will be dropped if it exists, then created.
- Truncate: If the table does not exist, it will be created. If the table does exist, then all its rows will be deleted.
on a feature type in the