Enabling outbound processing

To configure outbound processing , you must set up and configure a process, such as a polling program or a trigger, to retrieve transactions from the MXOUT_INTER_TRANS queue table.

Before you begin

To use interface tables, you must create the tables.

Procedure

  1. Set up a process to retrieve interface table transactions by using the MXOUT_INTER_TRANS queue table. You can use a polling program, a trigger, or any other mechanism.
  2. For the polling program to process transactions sequentially configure it to read the records in the MXOUT_INTER_TRANS queue table in the TRANSID sequence.
  3. Enable each record in the MXOUT_INTER_TRANS queue table:
    1. Access the interface table that you just identified, and retrieve the first record in which the TRANSID value matches the TRANSID value in the current MXOUT_INTER_TRANS queue record. If the interface table contains multiple records with the same TRANSID value, retrieve and process them in TRANSSEQ sequence.
    2. Process data according to the value in the ACTION column of the interface queue table.
  4. Commit all records for a single database transaction.
  5. Delete the current record from the MXOUT_INTER_TRANS queue table.

What to do next

Implement error management, based on your external system requirements.