Page 1 of 1

Maximum number of include/omit cond

PostPosted: Sat Nov 07, 2009 9:41 pm
by xcspg3
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

Re: Maximum number of include/omit cond

PostPosted: Mon Nov 09, 2009 10:33 pm
by Frank Yaeger
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?

Re: Maximum number of include/omit cond

PostPosted: Sun Nov 15, 2009 6:59 pm
by xcspg3
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

Re: Maximum number of include/omit cond

PostPosted: Mon Nov 16, 2009 11:31 pm
by Frank Yaeger
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

Re: Maximum number of include/omit cond

PostPosted: Sat Nov 21, 2009 8:57 pm
by xcspg3
Thanks

max