IBM Mainframe Forum

Hi,
I have two little questions:
- the maximum number of include/omit cond in a single step of dfsort
- the maximum number of rows for the SYSIN of dfsort

Can you help me?

max

The maximum number of INCLUDE/OMIT conditions depends on the length and type of the field and constant. If you show me an example of your INCLUDE condition, I may be able to give you an estimate.

By "rows", do you mean lines or something else? Approx. how many lines do you need?

Data set has LRECL=80, RECFM=FB and 1.000.000 or more lines.
The SYSIN is
INCLUDE COND=(3,16,CH,EQ,C'0000000000000001',OR,
3,16,CH,EQ,C'0000000000000002',OR,
...
3,16,CH,EQ,C'000000000000000N')
SORT FIELDS=COPY
where C'....' is a string of 16 chars.
The step before DFSORT creates the include cond with a variable mumber of 3,16,CH,EQ,C'...'.
My question is about the maximum number of 3,16,CH,EQ,C'...' that I can use.
The other question is about the maximum number of lines for a SYSIN.

Thanks
Max

For that type of condition, the maximum would be about 1240. The maximum number of lines depends on the storage available, but the number of conditions will be exceeded long before the number of lines is.

If you have more than 1240 conditions, you might want to consider using a matching solution instead of an INCLUDE solution. For more information, see the various techniques described in the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss? ... g3T7000094

Thanks

max