View previous topic :: View next topic
|
Author |
Message |
bamohan
New User
Joined: 29 Jan 2007 Posts: 33 Location: chennai
|
|
|
|
If we have include condition in DFSORT. How the sort will function whether it first sort the records and then fetch the row based on the include condition or will it do in vice-versa.. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
If the include is working on the input, before the actual sort, less records will be actually sorted resulting in less cpu resources being used.
If the include is working on the output then all records will be sorted. |
|
Back to top |
|
|
bamohan
New User
Joined: 29 Jan 2007 Posts: 33 Location: chennai
|
|
|
|
Sorry.. Still I'm not clear.. See I have this sort code in My JCL
SORT FILEDS=(1,9,CH,A)
INCLUDE COND=(1,3,CH,EQ,C'AAA')
Here, Whether the sorting will performed first or the records are fetched based on the include condition and then sort will be perfomed ? |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Code: |
SORT FIELDS=(1,9,CH,A)
INCLUDE COND=(1,3,CH,EQ,C'AAA')
|
Since you're using an INCLUDE statement, it will be processed before sorting. The order in which you specify the statements does not matter.
If you want the INCLUDE to be processed after sorting, you can use an OUTFIL statement with an INCLUDE operand:
Code: |
SORT FIELDS=(1,9,CH,A)
OUTFIL INCLUDE=(1,3,CH,EQ,C'AAA')
|
|
|
Back to top |
|
|
|