Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Report using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Report using SYNCSORT
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

Site Director


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

PostPosted: Fri May 18, 2007 2:26 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us