View previous topic :: View next topic
|
Author |
Message |
JayC
New User
Joined: 27 Sep 2008 Posts: 70
|
|
|
|
Hi,
Could someone help me with the following :
I need to select records from my input file based on the values from two fields in the same record being equal.
Eg -
INPUT
Code: |
120080901JAY123JOEXYZ
120080901JAY123JAYUTC
120080901JAY123ANNYTS
120080901JOE123JOEUTC
120080901JAY123JIMUUV |
OUTPUT
Code: |
120080901JAY123JAY UTC
120080901JOE123JOE UTC |
I need to select the records if the valeus in the columns 10 to 12 and columns 16 to 19 are equal.
[/code] |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
JayC,
From your previous posts, I can see you are using Syncsort and not DFSORT. Questions related to Syncsort should be raised in JCL forum and not in DFSORT forum. Please keep this in mind for future posts.
You can achieve this using the INCLUDE parameter.
Code: |
//SYSIN DD *
OPTION COPY
INCLUDE COND=(10,3,CH,EQ,16,3,CH) |
|
|
Back to top |
|
|
JayC
New User
Joined: 27 Sep 2008 Posts: 70
|
|
|
|
Thanks, Didn't find a SYNCSORT forum so posted it here.
Will keep it in mind.
Thanks for the help. I guess it was simpler than I thought. |
|
Back to top |
|
|
|