Join Paired Problem
Posted: Wed Oct 19, 2011 8:21 pm
Hi,
I have two files, both have LRECL=849 and RECFM=FB.
I wanted to extract ONLY Matching records from Second File, the criteria for matching is 44,22.
File 1 has 67990 Records and File 2 has 104202 Records.
Below is the Sort Card I have used.
Below is the messages from SORTLIST in SYSOUT
Can someone please let me know why I got 1507 records when there are only 991 Paired records in File2.
Do i need to change my SORT CARD to get only Matching Records from FILE2.
I have two files, both have LRECL=849 and RECFM=FB.
I wanted to extract ONLY Matching records from Second File, the criteria for matching is 44,22.
File 1 has 67990 Records and File 2 has 104202 Records.
Below is the Sort Card I have used.
//SORTJNF1 DD DISP=SHR,DSN=FILE1
//SORTJNF2 DD DISP=SHR,DSN=FILE2
//SYSIN :
JOINKEYS FILE=F1,FIELDS=(44,22,A)
JOINKEYS FILE=F2,FIELDS=(44,22,A)
REFORMAT FIELDS=(F2:1,849)
SORT FIELDS=COPY
//SORTJNF2 DD DISP=SHR,DSN=FILE2
//SYSIN :
JOINKEYS FILE=F1,FIELDS=(44,22,A)
JOINKEYS FILE=F2,FIELDS=(44,22,A)
REFORMAT FIELDS=(F2:1,849)
SORT FIELDS=COPY
Below is the messages from SORTLIST in SYSOUT
WER901I **WARNING** SYNCSORT 1.4.0.0 WILL EXPIRE IN 53 DAYS
WER481I JOINKEYS REFORMAT RECORD LENGTH= 849, TYPE = F
WER110I SORTOUT : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER074I SORTOUT : DSNAME=OUTFILE
WER054I RCD IN 1507, OUT 1507
WER072I NOEQUALS, BALANCE IN EFFECT
WER169I RELEASE 1.4 BATCH 0518 TPF LEVEL 0.0
WER482I JNF1 STATISTICS
WER108I SORTJNF1 : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER073I SORTJNF1 : DSNAME=FILE1
WER484I SORTJNF1 : RCD IN= 67990,OMITTED= 0,PAIRED= 825,UNPAIRED= 67165
WER487I FILESIZE 57,723,510 BYTES
WER482I JNF2 STATISTICS
WER108I SORTJNF2 : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER073I SORTJNF2 : DSNAME=FILE2
WER484I SORTJNF2 : RCD IN= 104202,OMITTED= 0,PAIRED= 991,UNPAIRED= 103211
WER487I FILESIZE 88,467,498 BYTES
WER481I JOINKEYS REFORMAT RECORD LENGTH= 849, TYPE = F
WER110I SORTOUT : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER074I SORTOUT : DSNAME=OUTFILE
WER054I RCD IN 1507, OUT 1507
WER072I NOEQUALS, BALANCE IN EFFECT
WER169I RELEASE 1.4 BATCH 0518 TPF LEVEL 0.0
WER482I JNF1 STATISTICS
WER108I SORTJNF1 : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER073I SORTJNF1 : DSNAME=FILE1
WER484I SORTJNF1 : RCD IN= 67990,OMITTED= 0,PAIRED= 825,UNPAIRED= 67165
WER487I FILESIZE 57,723,510 BYTES
WER482I JNF2 STATISTICS
WER108I SORTJNF2 : RECFM=FB ; LRECL= 849; BLKSIZE= 27168
WER073I SORTJNF2 : DSNAME=FILE2
WER484I SORTJNF2 : RCD IN= 104202,OMITTED= 0,PAIRED= 991,UNPAIRED= 103211
WER487I FILESIZE 88,467,498 BYTES
Can someone please let me know why I got 1507 records when there are only 991 Paired records in File2.
Do i need to change my SORT CARD to get only Matching Records from FILE2.