Assume a file includes a transaction code in columns 17 to 23 (7 characters in length), and a transaction amount in columns 30 to 38 (9 characters in length). These two fields comprise the record key.
The Control-M/Analyzer rule below illustrates how to define this key to the Control-M/Analyzer Reconciliation facility.
The first block, SETKEY, initializes the variables necessary for performing the Preparation stage through the SETKEY function and performs this function on the file.
Subsequent blocks perform the reconciliation.
Figure 364 Reconciliation Function SETKEY Example
LIBRARY : CTB.PROD.RULES RULE : SETKEY
COMMAND ===> SCROLL===> CRSR
+-----------------------------------------------------------------------------+
OWNER M43 GROUP BANKING_DEPARTMENT
UPDATED 08/08/00 - 15:32:32 BY M43
DESC RECONCILIATION FACILITY SETS KEY FIELDS
OPTIONS
===========================================================================
EXECUTE SETKEY UPON C
ON DATA
ALWAYS
DO SET = RECFUNC='SETKEY' C
DO SET = LEN1=7 C
DO SET = LEN2=9 C
DO SET = OFFSET1=17 C
DO SET = OFFSET2=30 C
DO SET = ARGNUM=4 C
DO CALLUSER = CTBRECL ARG RECFUNC,ARGNUM,OFFSET1,LEN1,OFFSET2,LEN2 C
===========================================================================
EXECUTE RECONCIL UPON C
ON DATA
PLEASE FILL IN RULE DEFINITION. 15.32.29
Parent Topic |