View previous topic :: View next topic |
Author |
Message |
lavan79 Beginner
Joined: 18 Oct 2005 Posts: 4 Topics: 2
|
Posted: Wed Nov 30, 2005 2:32 pm Post subject: Getting Non matching records from 2 files |
|
|
Hi,
I have a file(FILE 1) with unique key values in 1-16 position. the contents of this file keeps changing everyday. But i need to compare this file to another input file(Key fields positions are the same) and remove records present in FILE 1 from FILE2. FILE 2 can have duplicate key values and both of them are FB but LRECL are different. I would like to know how this can be done using syncsort?
Thanks |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
|
Posted: Wed Nov 30, 2005 2:43 pm Post subject: |
|
|
lavan79,
Run the following Job and post the sysout of the job here. This will help use to provide the solution based on the version of syncsort you have
Code: |
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
ABC
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
/*
|
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
lavan79 Beginner
Joined: 18 Oct 2005 Posts: 4 Topics: 2
|
Posted: Wed Nov 30, 2005 2:56 pm Post subject: |
|
|
SYNCSORT FOR Z/OS 1.2.0.1R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSORT INC.
z/OS 1.5.0
WER169I RELEASE 1.2 BATCH 0453 TPF LEVEL 0.1
Let me know if this is sufficient or do i need to provide some more details. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
|
|