IBM BJ0NJML Integration Guide - Page 120

Configuring External Systems Configuring External Systems Overall Processing Inbound Processing Inbound Null Columns To use interface tables, you must create the tables and configure the IFACETABLECONSUMER cron task. To configure the external systems to perform general interface queue table and interface table processing: 1 Define procedures to restore the backups of the interface tables. 2 Create interface tables in the user interface. 3 Manage the archiving of interface tables. To configure the external system to perform inbound interface queue table and inbound interface table processing: 1 Create and initialize the outbound TRANSID counter. 2 Create records for each interface table that an inbound transaction writes to: a Create an interface table record and populate it with the following information: „ The transaction data „ The incremented TRANSID value „ If multiple records exist for the same interface table, the incremented TRANSSEQ value b Create an MXIN_INTER_TRANS queue record with the following information: „ The same TRANSID value that is contained the interface table record „ The name of the enterprise service that corresponds to the interface table, in the IFACENAME column „ Optional: The ACTION value „ The identifier of the external system, in the EXTSYSNAME column c Perform a single commit, to commit all records for a transaction at one time. If a column in an interface table contains a null value, the applicable objects process the column in the following ways: „ By default, the field is not updated by the transaction. „ If you add the empty tag when you are using a user exit, the object adds a null value to the field in the system database. 106 Integration Guide