Using Opcodes to Set Operations for Subscription Service

In TIBCO Business Studio, when you use a Publish to Adapter activity to publish messages to Subscription Service, you can set the ADB_OPCODE field to specify insert, update, delete, and upsert operations for Subscription Service.

In the Publish to Adapter Input tab, click aePubInputType > body > Table_Name to find the ADB_OPCODE field, as shown in the following figure.

To specify an operation for Subscription Service, set the field to any of the following values:
  • 1: indicates insert.
  • 2: indicates update.
  • 3: indicates delete.
  • 4: indicates upsert. (If the primary key exists in the table, 4 indicates update; if the primary key does not exist, 4 indicates insert.)