DB2/AS400 Options Tab

This tab is displayed when you select DB2 AS400 from the Vendor list on the Configuration tab of the adapter instance.

Trigger Option

The new data from the source table is copied to the publishing table by setting the trigger options. You can select from the following options:

•

SQL: the trigger program is defined entirely by using SQL. SQL trigger can be insert, update, or a delete triggers. When copying from the source table to the publishing table, the prompt is not returned until all data is written. Currently only SQL trigger can be used for DB2 AS400.

•

Synchronous (not applicable): the trigger is written in RPG. When copying from the source table to the publishing table, the prompt is not returned until all data is written.

•

Asynchronous (not applicable): when data is copied from the source table, data is inserted into a data queue and then inserted into the publishing table asynchronously. This process is not blocked, so you can continue working while data is inserted into the publishing table.