IBM SG24-6526-00 manual User profiles, System21 data setup, Database triggers

–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.

Chapter 4. Installing and setting up vendor.connect 87