socker_dad
Active User
Joined: 05 Dec 2006
Posts: 177
Location: Seattle, WA
|
|
|
|
I've browsed through the previous posts and can't find a solution that actually works for the situation I have. I also have read the SyncSort manual and the Join manual, but can't get their solutions to work either!
We use SYNCSORT FOR Z/OS 1.2.2.2R.
I have two files with a 7 number customer ID in them - although in different positions. I need to produce a 3rd file with ONLY the customer IDs from File 1 that are present in File 2.
File 1 has 965 records, key begins in column 3, length of 7.
File 2 has 974 records, key begins in column 17, length of 7.
File 3 should only have the matching customer IDs.
Here are my SyncSort statements:
| Code: |
//SORTJNF1 DD DSN=MV603.TEMP.CUSTIDS,
// DISP=SHR
//SORTJNF2 DD DSN=MVD.MV603.DLZZ.DISK.D55001.NLS,
// DISP=SHR
//SORTOUT DD DSN=MV603.TEMP.D55001,
// DISP=(NEW,CATLG,CATLG),
// DCB=(RECFM=FB,LRECL=080,BLKSIZE=0),
// UNIT=DISK,SPACE=(TRK,(05,05),RLSE)
//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(03,07,A)
JOINKEYS FILES=F2,FIELDS=(17,07,A)
REFORMAT FIELDS=(F1:03,07)
SORT FIELDS=COPY
/*
|
The resulting file contains all the customer ids from File 2.
What am I doing wrong? |
|
socker_dad
Active User
Joined: 05 Dec 2006
Posts: 177
Location: Seattle, WA
|
|
|
|
Ah crap. Don't mind me - I'm wandering around with the little animals.
Turns out that the systems programmers did a test environment refresh this weekend and wiped out all the Customer IDs with which I had been working - making the results of the job accurate: useless, but accurate. 
Thanks for the feedback and patience!
I'll go hide in my corner now....... |
|
