JOINKEYS

FIELDS operand: You can use symbols where you can use fields (p,m). A symbol for p,m,f results in substitution of p,m.

INCLUDE and OMIT operands: You can use symbols where you can use fields (p1,m1,f1 and p1,m1 and p2,m2,f2 and p2,m2) and constants (n, +n, -n, C'xx...x', X'yy...yy', Y'yyx...x' and B'bbbbbbbb...bbbbbbbb'). A symbol for p,m,f results in substitution of p,m if symbol,f is specified. A symbol for 'string' always results in substitution of C'string'.

Note: You can use a symbol for Y'DATEx', Y'DATEx'+n or Y'DATEx'-n (where x is 1, 2 or 3) in the INCLUDE or OMIT operand, but you cannot use symbol+n or symbol-n to substitute Y'DATEn'+n or Y'DATEn'-n in the INCLUDE or OMIT operand. See the discussion of "INCLUDE and OMIT" for further details.

STOPAFT=n operand: You can use a symbol where you can use a number (n) with the STOPAFT operand.

Example 1

  JOINKEYS FILE=F1,FIELDS=(Division,A),
    INCLUDE=(Substring,EQ,Depts)

will be transformed to:

 JOINKEYS FILE=F1,FIELDS=(3,10,A),INCLUDE=(16,3,SS,EQ,C'J82,L92,M72')