Writer Directives

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>