IBM BJ0NJML - Service And Asset Management - View Collaboration Switches

View Collaboration Switches
292
Integration Guide
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 mxcollab
where 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;