IBM Informix Spatial Writer: Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.

All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also control Dynamic Properties.

These parameters apply only to a selected feature type, not to the entire writer.

Tip: If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.

The configuration parameters present are described in the following table:

Parameter	Contents
infx_type	This specifies the type of geometry the features to be written to the layer will have.
infx_overwrite_table	This parameter can be set to one of `<YES\|NO\|TRUNCATE>`. YES: The table will be dropped if it exists, and then created. NO: The table will be created if it does not exist. TRUNCATE: The table will be created if it does not exist. If the table exists, all the rows from the table will be deleted.
infx_update_key_ columns	This instructs the Informix Spatial writer to perform an `UPDATE` operation on the table, rather than performing an `INSERT`. The argument is a comma-separated list of the columns which are matched against the corresponding FME attributes’ values to specify which rows are to be updated with the other attribute values. For example: infx_update_key_columns ID,NAME In this case the FME attribute is always matched against the Informix column with the same name. Also, the target table is always the feature type specified in the `DEF` line. Each column listed with the `infx_update_key_columns` directive must be defined with a type on the `DEF` line, in addition to the columns whose values will be updated by the operation. This cannot be used with `infx_delete_key_columns`. Also, the keys cannot be of type `BLOB, CLOB`, or `LONG_VARCHAR`.
infx_delete_key_ columns	This instructs the Informix Spatial writer to perform a `DELETE` operation on the table, rather than performing an `INSERT`. The argument is a comma-separated list of the columns which are matched against the corresponding FME attributes’ values to specify which rows are to be deleted when their values match the other attribute values. For example: `infx_delete_key_columns ID,NAME` would delete those rows in the table whose values match the attribute values passed in through this `DEF` line. The FME attribute is always matched against the Informix Spatial column with the same name. Also, the target table is always the feature type specified in the `DEF` line. Each column listed with the `infx_delete_key_columns` directive must be defined with a type on the `DEF` line, in addition to the columns whose values will be updated by the operation. This cannot be used with `infx_update_key_columns`. Also, the keys cannot be of type `BLOB, CLOB`, or `LONG_VARCHAR`.
infx_geometry_column	This parameter can be used to specify the name of the spatial layer (geometry column name). If it is not specified the default name of “geometry” will be used for the spatial layer.
infx_multi_geometry	This parameter is in effect only when creating a new table. It specifies whether geometry features should be written as multi geometries (e.g. ST_MULTIPOINT) or single geometries (e.g., ST_POINT). YES: The table created has multi geometries (for example, when the geometry column type is ST_MULTIPOINT, point features are aggregated as IFMEMultiPoints and written out as ST_MULTIPOINT values). NO: The geometry column of the created table is singular (that is, ST_POINT), and IFMEMulti geometries are split (e.g., IFMEMultiPoint split into IFMEPoints). FIRST_FEATURE: The type of the geometry column will be determined based on the first feature entering the writer. For example, if the first feature contains an IFMEPoint, then the geometry column type will be ST_POINT. Note that of the three options, YES is the least lossy. With NO and FIRST_FEATURE, it is possible to have a single IFMEMultiPoint feature be broken up into multiple IFMEPoints, which would result in multiple rows in the target table.
infx_offset_x infx_offset_y	This parameter is enabled only when creating a new table. infx_offset_x and infx_offset_y correspond to the columns FALSEX and FALSEY in the system table SDE.SPATIAL_REFERENCES. This parameter specifies the minimum x (y) coordinate of the spatial reference system for the target table. If a geometry feature has x (y) coordinates below this value, then the feature is rejected or translation is aborted depending on the value of the writer directive ABORT_ON_BAD_DATA.
infx_scale_x	This parameter is enabled only when creating a new table. This parameter specifies the resolution of the spatial reference system. The resolution of the spatial reference system is equal to 1 divided by infx_scale_x. For example, if infx_scale_x is 1, all coordinates will be rounded to integers. As another example, if infx_scale_x is 10, 1/10 is 0.1, and all coordinates will be rounded to the nearest 0.1, which means a coordinate value of 2.149 will be written as 2.1. infx_scale_x corresponds to the column XYUNITS in the system table SDE.SPATIAL_REFERENCES. The parameters infx_offset_x, infx_offset_y, and infx_scale_x together define the maximum x and y coordinates in the spatial reference system for the target table. If a geometry feature has x (y) coordinates above these maximums, then the feature is rejected or translation is aborted depending on the value of the writer directive ABORT_ON_BAD_DATA.
infx_srid	The SRID that will be attached to all geometry. This SRID must exist in the `SPATIAL_REFERENCE` table. If left blank, the SRID will be determined from the feature coordinate system.