The directives processed by the SpatialWare writer are listed below. The suffixes shown are prefixed by the current <WriterKeyword> in a mapping file. By default, the <WriterKeyword> for the SpatialWare writer is SPATIALWARE.
DATASET, IDs, SERVER_VERSION, SERVER_TYPE, USER_ID, PASSWORD
These directives operate in the same manner as they do for the SpatialWare reader. The remaining writer-specific directives are discussed in the following sections.
DEF
Required/Optional: Optional
This clause instructs describes a database table which the SpatialWare writer module uses for inserting or updating features. This table may be created if it does not already exist. Details on the specific syntax of the DEF statement are provided in SpatialWare Table Representation.
TRANSACTION
Required/Optional: Optional
This clause instructs the SpatialWare writer module to use transactions when loading data into SpatialWare. The SpatialWare writer does not write any features to SpatialWare until the feature is reached that belongs to <last successful transaction> + 1. Specifying a value of 0 causes the SpatialWare writer to use transactions and to write every feature to SpatialWare. Normally, the value specified is zero—a non-zero value is only specified when a data load operation is being rerun.
If the SPATIALWARE_TRANSACTION statement is not specified, then transactions are not used during the data load operation.
|
Parameter |
Contents |
|
<last successful transaction> |
The transaction number of the last successful transaction. When loading data for the first time, set this value to 0. |
Example:
SPATIALWARE_TRANSACTION 0
Workbench Parameter: Last Committed Transaction <for sqlserver only>
TRANSACTION_INTERVAL
Required/Optional: Optional
This clause informs FME about the number of features to be placed in each transaction before a transaction is committed to the database.
If the SPATIALWARE_TRANSACTION_INTERVAL statement is not specified, then a value of 100 is used as the transaction interval.
|
Parameter |
Contents |
|
<transaction_interval> |
The number of features in a single transaction. |
Example:
SPATIALWARE_TRANSACTION_INTERVAL 50
Workbench Parameter: Features per Transaction <for sqlserver only>