Does TIBCO ActiveMatrix BusinessWorks Plug-in for Database support modified trigger script and stage table(P_Table)?

Does TIBCO ActiveMatrix BusinessWorks Plug-in for Database support modified trigger script and stage table(P_Table)?

book

Article ID: KB0076226

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 7.2,8.x

Description

Does TIBCO ActiveMatrix BusinessWorks Plug-in for Database  support modified trigger script and stage table(P_Table)?

Environment

================== Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version: 7.2,8.x OS: All Supported Operating Systems ==================

Resolution

TIBCO ActiveMatrix BusinessWorks Plug-in for Database(i.e. adapter) cannot support the modified trigger script and stage table(P_Table).
The stage table(P_Table) is an internal component of the TIBCO ActiveMatrix BusinessWorks Plug-in for Database working mechanism, and it shall not be used for any other purposes, and only the default trigger script generated by the TIBCO ActiveMatrix BusinessWorks Plug-in for Database at design time shall be used to insert data to the stage table, with no update/delete operations by other scripts or applications.

Do not modify the triggers generated by TIBCO ActiveMatrix BusinessWorks Plug-in for Database(i.e. adapter)as well as do not use stage table(P_Table) for any other purposes. 

Issue/Introduction

TIBCO ActiveMatrix BusinessWorks Plug-in for Database cannot support the modified trigger script and stage table(P_Table)