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

Need to compare two files using SYNCSORT


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

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Fri Feb 22, 2008 9:55 am
Reply with quote

Hi All,
I need to compare two files. One file contains the sequence number. Other contains header, data and trailer.
Header contains the sequence number and trailer contains the total number of records.

Sequence number file is 5bytes length. Ex. 12345
Details of second file:
H2102200812345
abd
saf
asdf
T000003

First i need to validate the sequence number and if matches, then i need to validate the trailer count whether the number of records read matches with the trailer count.

Currently I'm using a PLI program to do the above. Is it possible to do the above using SYNCSORT tool. Is that an efficient way?


FYI... My environment dont have DFSORT installed. We have only SYNCSORT v1.1

Please let me know the possibilities.


Regards,
ursvmg
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Feb 22, 2008 10:45 am
Reply with quote

ursvmg wrote:
FYI... My environment dont have DFSORT installed. We have only SYNCSORT v1.1
You know this & still the post is in DFSORT forum. Here in this forum Syncsort related queris are discussed under JCL forum.
Back to top
View user's profile Send private message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Fri Feb 22, 2008 11:25 am
Reply with quote

Oh.. I'm sorry. Will do it properly hereafter ..
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Fri Feb 22, 2008 12:31 pm
Reply with quote

AFAIK... you need version 1.2 in order to use the JOIN feature.
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 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
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
No new posts How to append a PS file into multiple... JCL & VSAM 3
Search our Forums:

Back to Top