IBM BJ0NJML - Service And Asset Management - Page 121

Configuring External Systems
Interface Tables 107
Outbound Processing To configure the external system to perform outbound interface queue table and
inbound interface table processing:
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:
a Read the records in the MXOUT_INTER_TRANS queue table in the
TRANSID sequence.
b Enable each record in the MXOUT_INTER_TRANS queue table:
 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.
 Process data according to the value in the ACTION column of the
interface queue table.
c Commit all records for a single database transaction.
d Delete the current record from the MXOUT_INTER_TRANS queue
table.
3 Implement error management, based on your external system requirements.