View previous topic :: View next topic
|
Author |
Message |
kaushik8205
New User
Joined: 10 Nov 2006 Posts: 49 Location: Canada
|
|
|
|
Hi,
I have a requirement in which I have to put 1500 include condition in Sort step.
But doing so gives an error as the maximum limit of include conditions has exceeded.
Please let me know how this requirement can be achieved.
Thanks. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
DFSORT has different limits for the number of conditions based on the length and format of the fields and constants.
You can get around these limits in several way. One way is to use multiple IFTHEN clauses as described in the Programmer Response for the message ICE151A you undoubtedly received. Another way is to do matching with SPLICE instead of using INCLUDE/OMIT.
If you need more specific help, please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is this the same question about how to match 1500 "people" with the larger file? |
|
Back to top |
|
|
kaushik8205
New User
Joined: 10 Nov 2006 Posts: 49 Location: Canada
|
|
|
|
Thanks Frank!
I worked on a solution by matching records in two files using SPLICE. It worked perfectly fine.
Regards,
Kaushik |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Good for you. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thanks for letting us know
d |
|
Back to top |
|
|
|