Where DFSORT formats can be used

The following tables show the statements, operands, and operators allowed with each of the various data formats.

Table 1. Allowed with Frequently Used Data Types
Statement, Operand, or Operator	CH	BI or FI	PD or ZD	FS or CSF	UFF or SFF	DTn, DCn, DEn, TMn, TCn, or TEn
DFSORT statements
INCLUDE	X	X	X	X	X
MERGE	X	X	X	X	X
OMIT	X	X	X	X	X
SORT	X	X	X	X	X
SUM		X	X
INREC statement operands
IFTHEN WHEN=(logexp)	X	X	X	X	X
IFTHEN BEGIN=(logexp)	X	X	X	X	X
IFTHEN END=(logexp)	X	X	X	X	X
FIELDS		X	X	X	X	X
BUILD		X	X	X	X	X
OVERLAY		X	X	X	X	X
IFTHEN BUILD		X	X	X	X	X
IFTHEN OVERLAY		X	X	X	X	X
OUTREC statement operands
IFTHEN WHEN=(logexp)	X	X	X	X	X
IFTHEN BEGIN=(logexp)	X	X	X	X	X
IFTHEN END=(logexp)	X	X	X	X	X
FIELDS		X	X	X	X	X
BUILD		X	X	X	X	X
OVERLAY		X	X	X	X	X
IFTHEN BUILD		X	X	X	X	X
IFTHEN OVERLAY		X	X	X	X	X
OUTFIL statement operands
INCLUDE	X	X	X	X	X
OMIT	X	X	X	X	X
IFTHEN WHEN=(logexp)	X	X	X	X	X
IFTHEN BEGIN=(logexp)	X	X	X	X	X
IFTHEN END=(logexp)	X	X	X	X	X
OUTREC		X	X	X	X	X
BUILD		X	X	X	X	X
OVERLAY		X	X	X	X	X
IFTHEN BUILD		X	X	X	X	X
IFTHEN OVERLAY		X	X	X	X	X
TRAILERx		X	X	X	X
IFTRAIL TRLID=(logexp)	X	X	X	X	X
IFTRAIL TRLUPD		X	X	X	X
ICETOOL operators
DISPLAY (ON, BREAK)	X	X	X	X	X	X
OCCUR (ON)	X	X	X	X	X	X
RANGE (ON)		X	X	X	X
SELECT (ON)	X	X	X	X	X
SPLICE (ON)	X	X	X	X	X
STATS (ON)		X	X	X	X
UNIQUE (ON)		X	X	X	X
VERIFY (ON)			X

Table 2. Allowed with Other Data Types
Allowed with Other Data TypesStatement or Operand	AQ	AC	FL	LS or CSL	TS or CST	OL or CLO	OT or CTO	ASL	AST	D1	D2	PD0	Y2x	Y4x
DFSORT statements
INCLUDE	X	X		X	X	X	X	X	X		X	X	X
MERGE	X	X	X	X	X	X	X	X	X	X		X	X
OMIT	X	X		X	X	X	X	X	X		X	X	X
SORT	X	X	X	X	X	X	X	X	X	X		X	X
SUM			X
INREC statement operands
IFTHEN WHEN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN BEGIN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN END=(exp)	X	X		X	X	X	X	X	X			X	X
FIELDS			X									X	X	X
BUILD			X									X	X	X
OVERLAY			X									X	X	X
IFTHEN BUILD			X									X	X	X
IFTHEN OVERLAY			X									X	X	X
OUTREC statement operands
IFTHEN WHEN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN BEGIN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN END=(exp)	X	X		X	X	X	X	X	X			X	X
FIELDS			X									X	X	X
BUILD			X									X	X	X
OVERLAY			X									X	X	X
IFTHEN BUILD			X									X	X	X
IFTHEN OVERLAY			X									X	X	X
OUTFIL statement operands
INCLUDE	X	X		X	X	X	X	X	X			X	X
OMIT	X	X		X	X	X	X	X	X			X	X
IFTHEN WHEN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN BEGIN=(exp)	X	X		X	X	X	X	X	X			X	X
IFTHEN END=(exp)	X	X		X	X	X	X	X	X			X	X
IFTRAIL TRLID=(exp)	X	X		X	X	X	X	X	X			X	X
OUTREC			X									X	X	X
BUILD			X									X	X	X
OVERLAY			X									X	X	X
IFTHEN BUILD			X									X	X	X
IFTHEN OVERLAY			X									X	X	X
ICETOOL operators
DISPLAY (ON)			X