MVSFORUMS.com

naveen_summary · Beginner Joined: 12 Feb 2007 Posts: 26 Topics: 13

Gurus,

Can this be achieved via Splice/ICETOOL.

File1:

Frank Yaeger · Posted: Tue May 29, 2007 11:46 am Post subject:

SPLICE cannot do that kind of Cartesian join.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

kolusu · Posted: Tue May 29, 2007 1:49 pm Post subject:

naveen_summary,

You can try the trick listed here

http://www.mvsforums.com/helpboards/viewtopic.php?t=6271&highlight=cartesian

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Frank Yaeger · Posted: Tue May 29, 2007 4:57 pm Post subject:

Hmmm ... I forgot about that Trick.

naveen,

Let us know if this is actually practical in your situation.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Phantom · Posted: Wed May 30, 2007 8:59 am Post subject:

I am updating the trick in our JCL/SORT FAQ Page (2 places). Please see the links below.

http://www.mvsforums.com/helpboards/viewtopic.php?p=40793#40793
http://www.mvsforums.com/helpboards/viewtopic.php?p=40794#40794

Thanks,
Phantom

Frank Yaeger · Posted: Fri Nov 20, 2009 1:30 pm Post subject:

With z/OS DFSORT V1R5 PTF UK51706 or z/OS DFSORT V1R10 PTF UK51707 (Nov, 2009), DFSORT now supports the JOINKEYS function which can do a Cartesian join. For this example, the DFSORT job would be: