SYNCSORT/SYNCTOOL : Is there a better way

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

Here is a job which when account #'s in both files are matching, compares rest of the data and if different write out difference or matching data.

And this job uses two steps:

santosh.ambaprasad · New User Joined: 08 Mar 2009 Posts: 16 Location: London

Hi

Try using SYNCTOOL........ let me know if you see any unexpected result..

Arun Raj · Posted: Thu May 14, 2009 9:04 am

MFRASHEED,

You can include those OUTFIL statements in your initial JOIN itself like this in order to accomplish this. And do remember to add OUT1 and OUT2 ddnames instead of SORTOUT.

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

Thanks to both of you, solution works.

Arun Raj · Posted: Fri May 15, 2009 12:37 am

You're welcome. Since you have SyncSort JOIN, I would recommend a simple Syncsort JOIN solution rather than a Synctool SPLICE job which would involve additional data passes.