| Parameter information for the above job: |
|
Parameter
|
Control Options
|
Description
|
Valid Values and/or Explanation of Examples
for Control Options
|
| %%PARM1= |
|
This process will only update or insert new row into two tables: pzrk1bl and pzrk1dp.
|
pzrk1bl - Update data or insert row into table pzrk1bl
pzrk1dp -
Update data or insert row into table pzrk1dp |
Note all inserted rows have the active indicator set to A:
PZRK1DP_active_ind = 'A'
PZRK1BL_active_ind = 'A'
All updated rows have the active indicator set to I:
PZRK1DP_active_ind = 'I'
PZRK1BL_active_ind = 'I' |
| %%PARM2= |
|
Inserts new row in the table or updates existing row in the table
|
I - Inserts new row in the table
|
| U - Updates existing row in the table |
| %%PARM3= |
|
Examples of inserting and updating recoreds.
(Actual values may vary)
|
PARM 3 CANNOT BE NULL
When the process is doing an insert, the value in PARM3 will indicate the value of a field in the row being inserted.
When the process is doing an update, the value in PARM3 will be used to select the row being updated.
|
| Building & Special Services
If inserting into pzrk1dp, value of PZRK1DP_EMPL_SELECTION field. In this example, if PARM1 is
PZRK1DP and PARM2 is I, we're inserting a row into PZRK1DP and the value of the PZRK1DP_EMPL_SELECTION field in the new row will be “Building & Special Services”. |
VOA Learning Ctr
If inserting into pzrk1bl, value of PZRK1BL_EMPL_SELECTION field. In this example, if PARM1 is
PZRK1BL and PARM2 is I, we're inserting a row into PZRK1BL and the value of the PZRK1BL_EMPL_SELECTION field in the new row will be “VOA Learning Ctr”. |
Building & Special Services
If updating pzrk1dp, value of the PZRK1DP_EMPL_SELECTION field for the record you're updating. In this example, if PARM1 is
PZRK1DP and PARM2 is U, we're updating PZRK1DP where PZRK1DP_EMPL_SELECTION = “Building & Special Services”. |
VOA Learning Ctr
If updating pzrk1bl, value of the pzrk1bl_EMPL_SELECTION field for the record you're updating. In this example, if PARM1 is
pzrk1bl and PARM2 is U, we're updating pzrk1bl where pzrk1bl_EMPL_SELECTION = “VOA Learning Ctr”.
|
| %%PARM4= |
|
Examples of inserting and updating recoreds.
(Actual values may vary)
|
PARM4 can only be left blank if you're updating pzrk1bl (if PARM1 is pzrk1bl and PARM2 is U)
|
| |
PFD Bldg & Special Services If inserting into pzrk1dp, value of PZRK1DP_K1_VALUE field. In this example, if PARM1 is:
PZRK1DP and PARM2 is I, we're inserting a row into PZRK1DP and the value of the PZRK1DP_K1_VALUE field will be “PFD Bldg & Special Services” in the new row. |
Example: A
If inserting into pzrk1bl, value of PZRK1BL_ACTIVE_IND field. In this example, if PARM1 is PZRK1BL and PARM2 is I we're inserting a row into PZRK1BL and the value of the PZRK1BL_ACTIVE_IND field will be “A” in the new row. |
PFD Bldg & Special Services
If updating pzrk1dp, value of the pzrk1dp_k1_value field for the record you're updating. In this example, if PARM1 is
pzrk1dp and PARM2 is U, we're updating pzrk1dp where pzrk1dp_k1_value = “PFD Bldg & Special Services”. |
Example: ""
If updating pzrk1bl (if PARM1 is pzrk1bl and PARM2 is U), leave blank (double quotes). |
| %%PARM5= |
|
Examples of inserting and updating recoreds.
(Actual values may vary) |
PARM5 can only be left blank if inserting into pzrk1bl or updating pzrk1dp or pzrk1bl. |
Example: A
If inserting into pzrk1dp (PARM1 is pzrk1dp and PARM2 is I), value of PZRK1DP_ACTIVE_IND. For example, we're inserting a row into PZRK1DP and the value of the PZRK1DP_ACTIVE_IND field will be “A”. |
Example: ""
If inserting into pzrk1bl (if PARM1 is pzrk1bl and PARM2 is I), leave blank (double quotes). |
Example: ""
If updating pzrk1dp (if PARM1 is pzrk1dp and PARM2 is U), double quotes (leave blank). |
Example: ""
If updating pzrk1bl (if PARM1 is pzrk1bl and PARM2 is U), double quotes (leave blank). |