JOINKEYS though SORT FIELDS=COPY



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

JOINKEYS though SORT FIELDS=COPY

Postby ranga_subham » Sat Sep 19, 2009 1:41 am

Hi,

The JOINKEYS is causing the output files in the sorted order though SORT FIELDS=COPY is mentioned. I don't want the SORT to happen but copy the records as they are from input to output.

How to achieve it?

TIA.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JOINKEYS

Postby dick scherrer » Sat Sep 19, 2009 1:56 am

Hello,

Is there some reason you did not post the jcl and sort control statements (use the Code tag)?

I don't want the SORT to happen but copy the recoreds as they are from input to output.
Confusing :?

JOINKEYS implies the data will be insequence. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: JOINKEYS

Postby ranga_subham » Sat Sep 19, 2009 2:11 am

Dick, my JCL and SORT card everything is working and am getting output but the only problem is data is appearing in sorted order. I don't want this to happen.

Actually, I am picking unique values from a file and trying to extract those values from some other huge file.

Thx.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JOINKEYS

Postby dick scherrer » Sat Sep 19, 2009 2:45 am

Hello,

And the jcl/sort control has still not been posted. . . :?

To repeat - JOINKEYS must have data in sorted order. . . It does not provide a random file search.

my JCL and SORT card everything is working and am getting output but the only problem is data is appearing in sorted order
Which means it is not really working. . . ;)
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: JOINKEYS

Postby arcvns » Sat Sep 19, 2009 8:21 am

dick scherrer wrote:To repeat - JOINKEYS must have data in sorted order. . . It does not provide a random file search.
Hi Dick,

May be I misunderstood your comment here. But JOINKEYS does n't need the input data to be in sorted order of the key. But the JOIN operation does sort both the input files on the key mentioned in the JOINKEYS statement before doing a file-match.

dick scherrer wrote:Actually, I am picking unique values from a file and trying to extract those values from some other huge file
ranga_subham,

Is your 'huge file' sorted on any field? Please provide the details requested here.
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: JOINKEYS

Postby dick scherrer » Mon Sep 21, 2009 2:29 am

Hi Arun,

Thanks for the correction. Dain Brammage. . . :oops:

I have no idea why, but i was thinking of a merge operation :?

Keep me in line :)


Thanks again,
d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: JOINKEYS

Postby arcvns » Tue Sep 22, 2009 7:59 pm

Hi Dick,

You're welcome. :D
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: JOINKEYS

Postby Alissa Margulies » Thu Oct 15, 2009 8:18 pm

If the original input files are "random" with no particular sequence, and the requirement is to maintain this random order in the output, you can pre-process the datasets to include a sequence number. Sort on that SEQNUM after JOIN processing, and then use OUTREC to strip off the SEQNUM.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post