i want to copy a set of records to an o/p whose first 1-7 ch report values are known. example if report numbers are 113893 , 122662 and 122665 then the o/p file shoud contain the records :
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
I assume that by posting in the JCl forum that your product is SYNCSORT rather than DFSORT.
Please use the search button at the top of the page as this topic has been discussed so many times before, with lots of ideas and solutions available in past threads.
Joined: 22 Sep 2008 Posts: 17 Location: Chennai, India.
can anyone tell me the difference between
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=01,
INCLUDE=(1,7,CH,EQ,C'113893',OR,
1,7,CH,EQ,C'114176')
-----------------AND-------------------
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=(1,7,CH,EQ,C'113893')
OUTFIL FILES=01,INCLUDE=(1,7,CH,EQ,C'114176')
I am not sure whether this second code is going to run? I am on hold to submit the JCL now.. Plz give suggestions .....
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Quote:
Can anybody flash light on reason behind it?
If you give the same file-id more than once in an OUTFIL group, Syncsort will process only the first OUTFIL and simply ignores the rest. Hope this helps
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Mukesh.py wrote:
can anyone tell me the difference between
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=01,
INCLUDE=(1,7,CH,EQ,C'113893',OR,
1,7,CH,EQ,C'114176')
-----------------AND-------------------
Regards,
Joined: 22 Sep 2008 Posts: 17 Location: Chennai, India.
i have not submitted it yet. authorization issue... in both the jcls i am trying to ask whether any one of them meets my requirement. 2nd one is for sure from the above discussions that it wont work.
i want to copy a set of records to an o/p whose first 1-7 ch report values are known. example if report numbers are 113893 , 122662 and 122665 then the o/p file shoud contain the records :
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
SyncSort for z/OS Release 1.3 Manual wrote:
• INCLUDE/OMIT statements with EQ/OR and NE/AND conditions can now be simplified from having to restate the same field data (p,l,f) when the field is compared with more than one constant.
For example,
INCLUDE COND=1,2,CH,EQ,C'NY',OR,1,2,CH,EQ,C'NJ',OR,1,2,CH,EQ,C'CT',OR,1,2,CH,...) can bewritten more simply as
INCLUDE COND=(1,2,CH,EQ,L(C'NY',C'NJ',C'CT',...)).
what L in 'L(C'113893 ',C'122662 ',C'122665 ')' means?
As per the same manual arcvns referred to:
Quote:
The compared constants are grouped together in parenthesis preceded by 'L' for 'list".
...If EQ is specified, the comparison conjunction OR is implied in the statement. If NE is specified, the comparison conjunction AND is implied in the statement...
Hope this helps. Let me know if you have any further questions.
