IFACETABLE handler
The IFACETABLE handler consists of several properties. This handler writes an outbound integration message to an interface table in a local or remote database.This handler writes an outbound integration message to an interface table in a remote database. There are no Java™ exit classes for this handler.
Only publish channels can use the IFACETABLE handler. Invocation channels cannot use this handler.
ISREMOTE property
This required property is a Boolean value that specifies whether interface tables are available in the local database or in a remote database. A value of 0 (false) indicates that the interface tables are available in the local database in the system schema. You do not have to enter any other handler properties. In the predefined MAXIFACETABLE handler, the value of this property is 0. A value of 1 (true) indicates the interface tables are in a remote database. If necessary, specify values for all the handler properties.
In a multitenancy environment, this property is set to a Boolean value of (1) and indicates that interface tables are in a remote database. You cannot change this value. If necessary, specify values for all the handler properties.
DRIVER property
This property specifies the JDBC driver to connect to a remote database that contains the interface tables. This property applies only when the value of the ISREMOTE property is 1.
URL property
This property specifies the JDBC URL and applies only when the value of the ISREMOTE property is 1. The following example contains the location, port number, and database name:
jdbc:db2://hostname:port/maximodbUSERNAME and PASSWORD properties
If access to the remote database requires a user name and password, these properties specify those values. These properties apply only when the value of the ISREMOTE property is 1.