IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort compare files and write in a new generation


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srajanbose

New User


Joined: 11 Oct 2004
Posts: 69
Location: chennai

PostPosted: Tue Jun 15, 2010 8:51 pm
Reply with quote

Hi,

I have a requirement as below.

input file : abc.xyz.

Code:
acc.no    name  age
0001      a         15
0002      b         20
0003      c         25
0004      d         30
0005      e         35


Output file1 : abc.cde(0)

Code:
acc.no    name  age   points
0001      a         15          34
0003      c         25          56
0005      e         35          67


Output file2 : abc.error

Code:
acc.no    name  age
0002      b         20
0004      d         30


previous generation of output file1 : abc.cde(-1)

Code:
acc.no    name  age   points
0001      a         15          34
0002      b         20          66
0003      c         25          56
0004      d         30          77
0005      e         35          67



I need to copy the records from previous generation input file to the current output file for the records present in error file.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Tue Jun 15, 2010 9:48 pm
Reply with quote

You should be able to use SyncSort's JOIN feature to accomplish this, but I am not quite clear what your requirements are.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top