Maximum number of include/omit cond
Posted:
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
Posted:
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
Posted:
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
Posted:
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