View previous topic :: View next topic
|
Author |
Message |
norm.flynn
New User
Joined: 08 Jan 2013 Posts: 20 Location: usa
|
|
|
|
Hi
So I have 2 files which can be matched on 1,8,ch
I want to check the value in column 26,5,bi in both files, only if they are different I want to write out an output record with the key and the both values (from the first file and the second file)
Using syncsort, input files are both FB, 132.
Let me know if you need any more info
Thanks
Norm |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
JOIINKEYS with 1,8 on both files.
No JOIN statement (so you only get the matches)
REFORMAT with key from one file (doesn'tmatter which) and data you need from F1 and F2.
OMIT COND=(for fields equal) in the Main Task. |
|
Back to top |
|
|
norm.flynn
New User
Joined: 08 Jan 2013 Posts: 20 Location: usa
|
|
|
|
tried the following but the job seemed to loop so I cancelled it, do you see anything wrong with the following sysin, wasn't sure about how to code the omit card
Code: |
JOINKEYS FILE=F1,FIELDS=(92,8,A)
JOINKEYS FILE=F2,FIELDS=(92,8,A)
REFORMAT FIELDS=(F1:92,8,F1:169,5,F2:169,5)
OUTFIL OMIT=(9,5,BI,EQ,14,5,BI)
SORT FIELDS=COPY |
|
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Because the Main Task is processed after the two JOINKEYS sub-tasks, you can just use OMIT COND=(, but with no other processing you shouldn't see much difference to what you have.
Are the files in sequence? Each of your inputs is being sorted. If they are in sequence, add ",SORTED" to the end of appropriate JOINKEYS statement.
Looping is difficult in SORT, as there are no looping-constructs. I'd guess you're not expecting the data to be sorted again.
The other thing which can chew up time is duplicate keys.
Run first with very small sample inputs, and check the start-position of the keys if you still have problems. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
tried the following but the job seemed to loop |
How did the job seem to loop?
Did you look to see fi the job was issuing I/Os or if there was only CPU being used?
Hopefully, you are Not trying to do your initial testing with full files . . . |
|
Back to top |
|
|
|