what is the usage and syntax of KEY parameter in TPFDF commands

Question

usage and syntax of KEY parameter in TPFDF commands

Answer 1

Upto 6 Key Parameters KEY1,KEY2..KEY6 Can be set up with a TPFDF Command macro , These must be specified in ascending order and are connected with Boolean AND Operation

 

If KEYn Parameters are specified Organisation of the keys also should be specified , Once Keys and Organisation are setup for a Subfile it remains in effect until another TPFDF macro is issued with another set of Key parameters or Keys are nullified using the NOKEY Parameter

 

EXAMPLE :

 

DBRED REF=TRABSQ,UP,KEY1=(R=TRABKEY,S=X'80'),

      KEY2=(R=TRABAWB,S=MI0ACC+10)

DBRED REF=TRABSQ,UP,KEY1=(R=TRABKEY,S=X'80'),

      KEY2=(R=D/TRABAWB-TRABKEY,S=MI0ACC+10)

DBRED REF=TRABSQ,UP,KEY1=(R=TRABKEY,S=X'80'),

      KEY2=(R=D/3,S=MI0ACC+10)