Chapter 4. Installing and setting up vendor.connect 87
– Name: *ALL
– Type: *FILE
– Attribute: PF-DTA
9. On the following display, type SJ next to each file that you want to journal. To journal
all
physical files, type SJ on the first line and press F13.
User profiles
The vendor.connect library list is controlled by a job description attached to a special user
profile as defined here.
Job description: The vendor.connect library list is set within a job description OSLVCF3
in the OSLVCF3 library that is supplied as already configured. If you must use other
.connect products, you must change this job description library list to include the extra
libraries.
User profile: You must create a user profile. As a standard, this should be called OSLVCF3.
This user must have its job description set to OSLVCF3 as explained earlier. Set the current
library to OSLVCF3. To create a user profile, enter the following command:
CRTUSRPRF USRPRF(OSLVCF3) CURLIB(OSLVCF3) TEXT(vendor.connect) JOBD(OSLVCF3/OSLVCF3)
System21 data setup
Follow these steps to set up the System21 data:
1. Using Data File Utility (DFU) or SQL, check the PM company profile record
OSLD1F3/PMP10. Note the value of the RAVN10 field (Receiving Address Vendor
Number).
2. Set the RECEIVINGADDRESSVENDOR field in OSLVCF3/COMPANYPROFILE to the
value in RAVN10.
3. Set NEXTSHIPMENTNUMBER = 0 and update it.
4. Create a record in file OSLVCF3/UNIQUEIDENTIFIER for each company on PMP10 with
file UNIQUEID = 0.
5. Check file OSLWFF3/WFP98 to ensure that it contains the following record:
HOST98 blank
PTAP98 MQ
PMRF98 TRIGGER.OUT
PMIF98 WM.TRIGGER.OUT
PVL198 0
PVL298 0
Database triggers
You must add database triggers to the following files:
In library OSLD1F3: PMP02, PMP03, PMP06, and PMP09
In library OSLPLF3: PLP05
To add database triggers, there must not be any locks on the file. For each file, you must add
*INSERT, *UPDATE, and *DELETE triggers. Use the following command to add an *INSERT
trigger to PMP02. Change the TRGEVENT parameter to create the *UPDATE and *DELETE
triggers:
ADDPFTRG FILE(OSLD1F3/PMP02) TRGTIME(*AFTER) TRGEVENT(*INSERT) PGM(OSLWFF3/WF500A)
RPLTRG(*YES) ALWREPCHG(*YES) THDSAFE(*UNKNOWN) MLTTHDACN(*SYSVAL) TRGUPDCND(*ALWAYS)
The TRGUPDCND is only necessary for the *UPDATE trigger.
