Publishing Table

Publishing tables mirror tables that you have identified for monitoring. They contain additional columns, primarily a sequence number and delivery status, which are required by the plug-in to detect new rows. You can create a publishing table for each table you want to activate in TIBCO Business Studio.

In addition to a copy of the source table columns, the publishing table has the following additional columns:

Column Name Type Description
ADB_SEQUENCE INTEGER Stores the monotonically increasing sequence number that represents new rows in the publishing table. If a column with this name exists, the number is generated automatically.

By default, the schema type is string. The plug-in treats this number as a string. This number can be larger than an integer if the database supports it.

ADB_TIMESTAMP DATE Time of row insertion in publishing table that is used to calculate expiration of rows. The timestamp is generated automatically.
ADB_OPCODE INTEGER Operation code used by the plug-in:
  • 1 indicates INSERT
  • 2 indicates UPDATE
  • 3 indicates DELETE
For more information about the upsert operation, see Upsert Operation on Parent-Child Tables.
ADB_REF_OBJECT VARCHAR2(64) When publishing by reference object is used, contains the name of the reference object that provides source data.
ADB_L_DELIVERY_STATUS

ADB_L_DELIVERY (for DB2)

CHAR Delivery status of Records:
  • N indicates that a new Record has arrived, but has not yet been published.
  • S indicates that one node has got this record, and is not taken again when polling other records.
  • C indicates complete.
  • F indicates failed.

Also see Child Table.