DB2/AS400 Options Tab
The DB2/AS400 Options tab is available only for Publication Service. This tab is displayed if you select DB2 AS400 from the Vendor list in the Configuration tab of an adapter configuration.
You can specify the trigger option in this tab so that new data from the source table can be copied to the publishing table. The following trigger options are available:
- SQL: the trigger program is defined entirely using SQL. The SQL trigger can be the insert, update, or delete trigger. When the adapter copied 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 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, data is inserted into a data queue and then inserted into the publishing table asynchronously. The prompt is not blocked, so the adapter can continue working when data is inserted into the publishing table.
Copyright © Cloud Software Group, Inc. All Rights Reserved.