Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
Assume you wish to subscribe into a table SF_PO_HEADERS_INTERFACE which has a child table SF_PO_LINES_INTERFACE joined by a foreign key on the column MESSAGE_ID:
1. configure a publication from the parent table, this generates a publication table (say SF_PO_HEADERS_IFACE_P) and repository classes for both tables.
2. configure a child relationship with table SF_PO_LINES_INTERFACE, this adds a sequence of child items to the publication class (SF_PO_HEADERS_IFACE_P).
3. configure a subscription into SF_PO_LINES_INTERFACE
4. configure a subscribing table relationship between SF_PO_HEADERS_INTERFACE and SF_PO_LINES_INTERFACE
5. publish a message contain the publishing class (SF_PO_HEADERS_IFACE_P) on the subject for subscription into SF_PO_LINES_INTERFACE
6. the data is inserted into the parent and child tables...