IBM Informix Non-Spatial Writer Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Window Layout > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Important  These parameters apply only to a selected feature type, not to the entire writer. 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.

Table Settings: General

  • 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.

This parameter instructs the writer to perform Update operations on the table.

The parameter is a comma-separated list of column names (for example, ID,NAME). These column names are used to match the same-named attributes on an input feature against rows in the destination table. Matching rows in the destination table will be updated by the attribute values of the input feature.

Note  If this parameter and Delete Key Columns are both supplied, the translation will fail.

This parameter instructs the writer to perform Delete operations on the table.

The parameter is a comma-separated list of column names (for example, ID,NAME). These column names are used to match the same-named attributes on an input feature against rows in the destination table. Matching rows in the destination table will be deleted.

Note  If this parameter and Update Key Columns are both supplied, the translation will fail.