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
 

 

Count using Syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
kumsv2005

New User


Joined: 12 May 2006
Posts: 1

PostPosted: Fri Dec 22, 2006 10:10 pm    Post subject: Count using Syncsort
Reply with quote

Hi,
I have a file which has records on a daily basis. I want to get the count of records on a weekly basis
For Eg:

Code:
03XX03459232006-12-03-20.
03XX03459232006-12-04-20.
03XX03459232006-12-05-20.
03XX03459232006-12-06-20.
03XX03459232006-12-07-20.
03XX03459232006-12-08-20.
03XX03459232006-12-09-20.
03XX03459232006-12-10-20.


I need to get the count on weekly basis(eg from 1204-1208)
is there anyway i can do this USING SYNCSORT.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sat Dec 23, 2006 6:55 am    Post subject: Re: Count using Syncsort
Reply with quote

okie... not sure how much I would be help of, as am a newbie for syncsort... let's try...

What I think a solution to the problem can be to filter records in temporary datasets for weekly basis and then count records from the temp file.

Now is there any constraint, that you would/wouldn't get a fix number of weeks in the input file.
Looking at the example it looks like, you are counting a week of 5 days, is that the understanding ?
We can hardcode values of date to be checked in condition, but this would be changing for weeks every next month.
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 Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm
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


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