DB2/AS400 Options Tab

The DB2/AS400 Options tab is displayed if you select DB2 AS400 from the Vendor list in the Configuration tab of an adapter configuration.

You can specify a trigger in the Trigger Option field to copy new data from the source table to the publishing table. The following trigger options are available:
  • SQL: the trigger program is defined entirely by using SQL. The SQL trigger can be an insert, update, or a delete trigger. When the adapter copies data from the source table to the publishing table, the prompt is not returned until all data is written. Currently only the SQL trigger can be used for a DB2 AS400 database.
  • Synchronous (not applicable): the trigger is written in RPG. When the adapter copies data from the source table to the publishing table, the prompt is not returned until all data is written.
  • Asynchronous (not applicable): when the adapter copies data from the source table, the data is inserted into a data queue and then inserted into the publishing table asynchronously. The prompt is not blocked, so the adapter continues working when the data is inserted into the publishing table.