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

Count using Syncsort


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1448
Location: Chicago, IL

PostPosted: Sat Dec 23, 2006 6:55 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
Search our Forums:

Back to Top