Posted: Wed May 23, 2007 4:44 pm Post subject: Syncsort Joinkeys
I have two files with a one to many relationship where JOINKEYS inner join seems to be the ticket - except that two one-byte fields need to be set with constant values indicated with the "?" below. In this case I need "22" at location 53 of the output record and 2's are not in either record.
I imagine I could do the joinkeys first and then OUTREC them in (what is likely) a second pass. If that's the case I am probably defeating the purpose of trying to improve the performance of the current COBOL implementation (both CPU and runtime).
In this case each file is over 80 million records.
I assume this function needs the SORT FIELDS statement.
I imagine I could do the joinkeys first and then OUTREC them in (what is likely) a second pass.
PaulPeplinski,
This can be done with JOINKEYS and either INREC or OUTREC, and requires only a single pass of the data. _________________ Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Joined: 26 Nov 2002 Posts: 12366 Topics: 75 Location: San Jose
Posted: Thu May 24, 2007 11:42 am Post subject:
Quote:
This can be done with JOINKEYS and either INREC or OUTREC, and requires only a single pass of the data.
INREC is supported with JOINKEYS? which version of syncsort supports it? I.e Can i have a seperate INREC statement for SORTJNF1 and another INREC statement for SORTJNF2 dd? Do you have an example?
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
SyncSort for z/OS 1.2 supports JOIN. JOIN processing logically replaces the reading of the SORTIN datasets. Other Phase 1 features, like INREC, INCLUDE, OMIT, and STOPAFT still can be used. While INCLUDE/OMIT can be specified on the JOINKEYS statement as well as a traditional INCLUDE/OMIT statement, INREC can modify a record created by the JOIN processing.
my question was to use seperate inrec for each SORTJNF DD
No... this is not possible now but anyting is possible in the future. _________________ Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
REFORMAT grabs the fields I need in the output record, INREC formats it with the constant '22' in the middle and pads it with the 43 bytes of FILLER.
Test run looked right, except it gives
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
Posted: Thu May 24, 2007 3:42 pm Post subject:
Thats nothing....Sort products gives you a warning when you try to increase the LRECL of the input file using INREC - bcas it has to process a much larger file than actual. That message is just an indication to use OUTREC or OUTFIL OUTREC to reformat records (whenever you can).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum