Syntax

   FACTORY_DEF <ReaderKeyword> DatabaseUpdaterFactory
      [FACTORY_NAME <factory name>]
      [INSERT FEATURE_TYPE <feature type>
         [<attribute name> <attribute value>]*
         [<feature function>]*]*
      [UPDATE FEATURE_TYPE <feature type>
         [<attribute name> <attribute value>]*
         [<feature function>]*]*
      [DELETE FEATURE_TYPE <feature type>
         [<attribute name> <attribute value>]*
         [<feature function>]*]*
      DBUPDATER_FORMAT_SHORT_NAME <format name>
      DBUPDATER_DATASET <dataset specifier>
      DBUPDATER_CONNECTION_PARAMS <connection parameters>
      DBUPDATER_TABLE <name of table to be updated>
      [DBUPDATER_UPDATE_COLUMNS <list of columns to update>]
      [DBUPDATER_KEY_COLUMNS <list of key columns>|DBUPDATER_WHERE_CLAUSE <SQL where clause>]

Overview

   This factory performs an update, delete, or insert with an FME writer for
   each feature it receives via its three corresponding input ports.  There
   is no output INITIATOR port because writers tend to de-const and mangle
   features (and don't want to incur overhead of copying features if not
   needed).

   Features that have an fme_where or fme_db_operation attributes are considered
   to be malformed and will result in an error.

   One, and only one, of DBUPDATER_KEY_COLUMNS and DBUPDATER_WHERE_CLAUSE 
   should be specified. DBUPDATER_WHERE_CLAUSE is the only directive that is
   re-evaluated for each feature.
   *** Might be able to specify neither if only doing INSERTs.


   Writer Specification
   ~~~~~~~~~~~~~~~~~~~~

   DBUPDATER_FORMAT_SHORT_NAME
      Type of writer that should be instantiated.

   DBUPDATER_DATASET
      FMEParsableText encoded dataset.

   DBUPDATER_CONNECTION_PARAMS
      Comma separated list of FMEParsableText encoded writer directive names and values
      required to establish a connection with the specified format.

   DBUPDATER_TABLE
      Table that updates/deletes/inserts will be performed against.

   DBUPDATER_UPDATE_COLUMNS
      Comma separated list of FMEParsableText encoded column names.  Only these columns
      will be updated.  Any of the listed columns not present on an input
      feature will be updated to null.  If no columns are specified, all columns
      will be updated.

   DBUPDATER_KEY_COLUMNS
      Comma separated list of FMEParsableText encoded column names.  These will be used to
      find matching records for UPDATE and DELETE features.  May not be used in
      conjunction with WHERE_CLAUSE.

   DBUPDATER_WHERE_CLAUSE
      Where clause used to find matching records for UPDATE and DELETE features.
      Will be evaluated on a per-feature basis to allow for attribute
      substitution.  May not be used in conjunction with KEY_COLUMNS.