Can delete operation be performed on the publishing table(P_Table)?
Article ID: KB0076230
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.x,8.x |
Description
Publishing tables(P_TableName) are the mirror tables that are used for monitoring the data. The table contains additional columns, primarily a sequence number and delivery status, which are required by the adapter to detect new rows. The TIBCO ActiveMatrix Database adapter does not remove the records from the publishing table automatically because that information needs to be retained for auditing purposes.
Issue/Introduction
Can delete operation be performed on the publishing table(P_Table)?
Environment
Product: TIBCO ActiveMatrix BusinessWorks Adapter for Database
Version: 7.x
OS: All Supported Operating Systems
Resolution
To manually remove the records from the given publishing table. Following command must be used which deletes all rows where ADB_L_DELIVERY_STATUS is C or F;
SQL> delete from publication_table_name where ADB_L_DELIVERY_STATUS = "C" or ADB_L_DELIVERY_STATUS = "F";
To automate the process, create the trigger with the above statement.
SQL> delete from publication_table_name where ADB_L_DELIVERY_STATUS = "C" or ADB_L_DELIVERY_STATUS = "F";
To automate the process, create the trigger with the above statement.
Feedback
Yes
No
Powered by
