IBM BJ0NJML Integration Guide - Page 306

View Collaboration Switches If the record exists, the system uses the record process control value to determine whether or not to bypass system processing. If the record exists, ignore the remaining steps. 7 If the record does not exist, the system modifies the key as follows: If System ID 1 now equals THISMX and System ID 2 does not equal THISMX, the system uses EXT as the System ID 2 value. If System ID 1 value does not equal THISMX and System ID 2 equals THISMX, the system uses EXT as the System ID 1 value. 8 The system tries to find a record with the modified key in the MXCOLLAB table. If the record exists, the system uses the record process control value to determine whether or not to bypass system processing. If the record exists, ignore the remaining step. 9 The system uses EXT for both System ID 1 and System ID 2. 10 The system finds the record with the modified key in the MXCOLLAB table. This record always exists, because every process control value has a default collaboration switch with both system IDs equal to EXT. 11 The system uses the record process control value to determine whether or not to bypass system processing. View Collaboration Switches You can use any database tool to display the values in the MXCOLLAB table. You can also create a report with the report-writing tools available in the system. To display the collaboration switches for a single process control ID, use the following SQL query: select pcid, owner1sysid, owner2sysid, pcvalue from where mxcollab pcid = 'PCID' order by pcid, owner1sysid, owner2sysid; To display all collaboration switches, use the following SQL query: select pcid, owner1sysid, owner2sysid, pcvalue from mxcollab order by pcid, owner1sysid, owner2sysid; To display a short description of the process control IDs, use the following SQL query: select * from mxcollabref order by pcid; 292 Integration Guide