IBM BJ0NJML Integration Guide - Page 307

Collaboration Switch Modification Collaboration Switch Modification Authorized users can use any database tool to modify the process control value of a collaboration switch. Do not change the value of PCID, OWNER1SYSID, or OWNER2SYSID on existing collaboration switches. To change the process control value in a collaboration switch, use the following SQL statement: update mxcollab set pcvalue = PCVALUE where pcid = 'PCID' and owner1sysid = 'OWNER1SYSID' and owner2sysid = 'OWNER2SYSID'; The values in the MXCOLLAB table are case-sensitive. Collaboration Switch Additions Authorized users can add new collaboration switches to the MXCOLLAB table. New switches must use an existing process control ID, but they can use new system IDs. Only the default collaboration switches can use the values THISMX and EXT in the system ID fields. To add a collaboration switch, use the following SQL statement: insert into mxcollab (pcid, owner1sysid, owner2sysid, pcvalue) values ('PCID', 'OWNER1SYSID', 'OWNER2SYSID', PCVALUE); For example, you want the integration framework to integrate the system with an Oracle Financials® system and other systems. When Oracle Financials issues system-owned inventory, you want the system to accept the issue and update inventory balances and costs. However, when other applications issue systemowned inventory, you want to accept the issue, but you do not want to update inventory balances or costs. 293