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

JCl to filter records and sum the records


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

New User


Joined: 12 Aug 2008
Posts: 11
Location: chennai

PostPosted: Wed Jun 10, 2009 5:25 pm
Reply with quote

Hi,
I have an requirement.I am having 4 flat files.I have to take common records from all file and sum up numerical values in the output file.

Eg:
file A : STEVE 0001
JOHN 0001

FIle B : STEVE 0005
CRAIG 0006

File C : STEVE 0007
JOHN 0002

FILE D : STEVE 0002
CRAIG 0004



OUTPUT : STEVE 15

I tried by merging the files and sort.its not working
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jun 10, 2009 5:38 pm
Reply with quote

Which SORT product does your site use ?
Back to top
View user's profile Send private message
aimprabhu

New User


Joined: 12 Aug 2008
Posts: 11
Location: chennai

PostPosted: Wed Jun 10, 2009 5:42 pm
Reply with quote

Hi ,

We are using SYNCSORT


Regards,

Prabhu
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(F1 & F2) and writ... JCL & VSAM 4
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top