DFSORT INCLUDE

on
What are the parameter types that go in INCLUDE=(??,?,??,EQ,C'??',AND,??,?,??,EQ,C'?')?
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
I am assuming you are refering to the OUTFIL INCLUDE option (vs. the INCLUDE COND=(xxxx) statement)

If you refer to page 103 in the manual

http://publibz.boulder.ibm.com/epubs/pdf/ice1ca50.pdf

It explains what the comparsions are.  For your statement:

INCLUDE=(??,?,??,EQ,C'??',AND,??,?,??,EQ,C'?')?

You would want to look at is as:

INCLUDE=(p1,m1,f1,EQ,constant,AND,p1,m1,f1,EQ,constant)

Commented:
Are the p1, m1, f1, and constant values, respectively, the same on both sides of that statement?
Top Expert 2014
Commented:
Not sure what you mean.  Although I will say at times IBM's manuals are a bit confusing if you are not used to using them.  After 30+ years I still get confused at times.

Think of the INCLUDE statement as a IF THEN ELSE statement

IF (A = "1") and (C = "2") then
include
else
don't include

A is equal to the first p1,m1,f1
B is equal to the second p1, m1, f1.

You have two unique sets of p1, m1, f1.  If you go  to page 104 it explains what p1, m1, and f1 are.   These are used to define the "field" you want to use: start, length, and format.

In your case you have two different fields and you only want to include the record when both fields are eq to some constant (C'?').  Now the constant could the the same constant in both cases or it could be different constants.

Commented: