Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us