These specific directives apply only to GeoMedia SQL Server Warehouses. For other GeoMedia directives, see Writer Directives – GeoMedia Access Warehouse and Writer Directives – all GeoMedia Warehouses.
The directives listed below are prefixed by the current <WriterKeyword> in a mapping file. By default, the <WriterKeyword> for the GeoMedia SQL Server Warehouse is FM0_SQL.
SQL_SERVER
Required/Optional: Required
Specifies the name of the server hosting the Microsoft SQL Server that stores the GeoMedia warehouse.
Range: String
Workbench Parameter: Server
USER_NAME
Required/Optional: Required
This is required only for GeoMedia SQL Server Warehouse. The username for the database must be supplied here, either through the command-line interface or the user interface settings for translation.
Workbench Parameter: User Name
PASSWORD
This is required only for GeoMedia SQL Server Warehouse. It will specify the password required to log in to the database specified by DATASET keyword.
Workbench Parameter: Password
START_TRANSACTION
This statement tells the writer when to start actually writing features into the database. The writer does not write any features until the feature is reached that belongs to <last successful transaction> + 1. Specifying a value of zero causes every feature to be output. Normally, the value specified is zero – a non-zero value is only specified when a data load operation is being resumed after failing partway through.
Parameter: <last successful transaction>
The transaction number of the last successful transaction. When loading data for the first time, set this value to 0.
Example:
FM0_SQL_START_TRANSACTION 0
Workbench Parameter: Start transaction at
TRANSACTION_INTERVAL
This statement informs the FME about the number of features to be placed in each transaction before a transaction is committed to the database. If the TRANSACTION_INTERVAL statement is not specified, then a value of 1000 is used as the transaction interval.
Example:
FM0_SQL_TRANSACTION_INTERVAL 1500
Workbench Parameter: Transaction interval
IMMEDIATE_WRITE
This statement instructs the FME to immediately write each row of data to the database, rather than batching up writes into bulk arrays. Bulk arrays are normally preferred, as they require fewer queries sent to the database in order to store the data.
Example:
FM0_SQL_IMMEDIATE_WRITE NO
Workbench Parameter: Immediate write