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)