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

Report using SYNCSORT


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

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu May 17, 2007 7:30 pm
Reply with quote

My criteria is as follows

file-1 of length 368 at position 100 has values 'ac' or ' ' and position 200 has an amount field in the format.-s9(5) v99

file-2 of length 80 position 50 has an amount value s9(5) v99
file-3 of length 700 at position 400 has an amount -s9(5) v99

I have to create a report saying

credit card --current date
count -- This should be equal to all the 'ac' in file 1 and the total records in file-2


Total amount -- total amount of file 1 with 'ac' and total amount in file 2


check payments --current date
count - This should be equal to all the ' ' in file 1 and the total records in file-3

Total amount -- total amount of file 1 with ' ' and total amount in file 3


My shop has only sysnsort ..so please could you provide me a soloution using syncsort..
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri May 18, 2007 2:26 am
Reply with quote

Hello,

While this might be done as you want with Syncsort, if you need this quickly, i'd suggest putting together a bit of code and getting your totals.
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 only first records of the fil... SYNCSORT 7
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
No new posts Report of batch jobs JCL & VSAM 1
Search our Forums:

Back to Top