You can insert, update, and delete data in a source table. If loop detection is enabled, the ADB_SOURCE column is added to the source table.
The following table lists and describes the additional column of the source table if loop detection is enabled:
| Column Name
|
Type
|
Description
|
| ADB_SOURCE
|
CHAR
|
Used for loop detection. Indicates whether the row is inserted or updated as a result of a TIBCO Rendezvous message, rather than user intervention.
The valid values are
T or
NULL:
- T indicates that the row is not to be published.
- NULL indicates the row can be published.
Note: If Subscription Service uses the same source table, you must reload the updated source table for Subscription Service after enabling loop detection. You must also ensure that the ADB_SOURCE column is displayed in the loaded table.
|
The source table cannot contain any user-created columns where the column name starts with ADB_. These characters are reserved for adapter use.
Copyright © Cloud Software Group, Inc. All rights reserved.
