## Maximum number of include/omit cond

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

### Maximum number of include/omit cond

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
xcspg3

Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time

### Re: Maximum number of include/omit cond

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?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Frank Yaeger
Global moderator

Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

### Re: Maximum number of include/omit cond

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
xcspg3

Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time

### Re: Maximum number of include/omit cond

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
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Frank Yaeger
Global moderator

Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

### Re: Maximum number of include/omit cond

Thanks

max
xcspg3

Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time