Interface table user exit class

When you use interface tables to receive messages from an external system, you can perform customization in the polling program that retrieves the data from the interface table and sends data to the system.

The cron task manager runs the interface table polling program. The IFACETABLECONSUMER cron task, has an optional EXITCLASS property where you can specify the fully qualified name of a Java™ exit class.

The Java data structure list represents the record from the interface tables, where the first element is always the action of the message. The remaining elements of the list are the mapped data structures and each map represents a row in the interface table for each message. The keys in the map are the column names and the values are the corresponding column values. All the column values are converted to their translated string format before they are set in the map.

The EXITCLASS class must implement the psdi.iface.intertables.IfaceTbExit interface and the following methods:

• public void beforeQueue(long transid, String extSys, String ifaceName, List data, Connection conn)

  This method is called after the data is received from the interface table and before the data is inserted into one of the inbound queues.

• public void afterCommit(long transid, String extSys, String ifaceName, Connection conn)

  This method is called after the data is inserted to an inbound queue and deleted from the interface queue table, and the database commit is done.

• public void afterRollback(long transid, String extSys, String ifaceName, Connection conn)

  This method is similar to the afterCommit method but is called if the transaction is rolled back.

This class can perform the following processes:

• Validate data.
• Change external data by changing the IR record to be saved in the system.
• Stop the transaction from being saved in the queue by throwing an exception. In this case, the transaction remains in the MXIN_INTER_TRANS table with the error message and is reprocessed.
• Stop the message from being sent to external system by throwing a skip_transaction exception. In this case, message the system does not save the message; the message is removed from the queue.
• Log the transaction

The user exit that uses the afterCommit or afterRollback method can perform the following processes:

• Perform custom processing and cleanup.
• Log the transaction.

You identify this class in the Cron Task Setup application.