Overwrite Existing File
Specifies whether the output file should be overwritten, if it exists.
By default, this parameter is checked (set to Yes). If you uncheck this option (set to No), then the SDF3 writer will append the new features to the dataset.
Default Schema Name
Defines the default schema name. Default means that the table name will contain the schema prefix separated by a period. For example, Default.MyTable.
Table Defaults
Overwrite Table
- 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.
Writer Mode
The default writer mode that will be set either on the feature types associated with the writer, or alternatively set on individual features.
At the feature type level, the writer mode is specified by this parameter. It may be superseded on individual features by the fme_db_operation format attribute.
Valid feature type writer modes are listed below:
| Mode | Description |
|---|---|
| Insert |
Appends features to the end of the sheet, or writes them to an exact row and/or column. Any data that already exists in that location will be overwritten. If there is a row value specified for the Row Number Attribute, that row will be used instead. |
| Update |
Causes the row corresponding to the feature’s value specified in the Row Number Attribute to have its data changed to the values on the incoming feature. If an attribute is missing on the incoming feature, the existing cell value will not be overwritten. |
| Delete |
Deletes the values in the row corresponding to the feature’s value specified in the Row Number Attribute. Only a number of columns equal to the amount of columns on the incoming feature will have their data and formatting removed. |
Default auto-generated identity column
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.
Geometry Column Name(s)
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.
Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.
This parameter has no effect when the Writer Mode is DELETE.
Advanced
X/Y Tolerance
Specifies the X/Y-axis tolerance values for the output SDF3 file. Valid values are floating-point numbers. The tolerances are in distance units that depend on the coordinate system. The default value is 0.0
Z Tolerance
Specifies the Z-axis tolerance values for the output SDF3 file. Valid values are floating-point numbers. The tolerances are in distance units that depend on the coordinate system. The default value is 0.0