Constant_names can be used in the following control statements:
INCLUDE
INREC
JOINKEYS
MERGE
OMIT
OUTFIL
OUTREC
RECORD
SORT
You can use a constant_name wherever you would specify a constant (X'nn...', B'bbbb,...',C'ccc...', Y'xx...'), that is:
-
A constant compared to a field in a data record (INCLUDE/OMIT)
-
A constant inserted into a data record (INREC/OUTREC, OUTFIL)
-
A constant used in a HEADERn/TRAILERn parameter, where n=1, 2, or 3 (OUTFIL)
You can use unsigned decimal constant_names as values for most keyword operands in control statements, such as the LENGTH operand that is used in the RECORD, INREC, OUTREC and OUTFIL control statements. For example, you can specify:
RECORD TYPE=V,LENGTH=reclen
where the constant_name is defined as
reclen,500
Unsigned decimal constant_names can be used for the following operands: ABSPOS, ACCEPT, ADDPOS, DO, ENDPOS, ENDREC, FIXLEN, ID, IFOUTLEN, INCR, LENGTH, LINES, MAXLEN, RECORDS, REPEAT, SAMPLE, SEQ, SKIPREC, SPLIT1R, SPLITBY, START, STARTPOS, STARTREC, STOPAFT and SUBPOS.
Note that you cannot use a dictionary_name for any of the following:
-
EDIT parameter
-
DATE parameter
Field_names can be used in the following MFX control statements:
DUPKEYS
INCLUDE
INREC
JOINKEYS
MERGE
OMIT
OUTFIL
OUTREC
RECORD
REFORMAT
SORT
SUM
You can use a field_name wherever you would specify a position, length, and format (p,l,f or p,l or p), a parsed field (%pp) or an output column.