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
 

 

sort card to display timestamp & no of occurance of it

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
gargi koley

New User


Joined: 11 Jan 2008
Posts: 10
Location: satyam gateway,hi-tech citi,hyderabad

PostPosted: Wed Mar 12, 2008 12:12 pm    Post subject: sort card to display timestamp & no of occurance of it
Reply with quote

hi all,

i need to get a sort card for a input file which has been already sorted based on account number (acen).

The input file looks like:

Acct No. Timestamp

1 T1
2 T2
3 T1
4 T3
5 T1
6 T2

The output file should look like :

Timestamp Count

T1 3
T2 2
T3 1

The comparision for the Timestamp is required only for date filed(1:10)[/u]
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Mar 12, 2008 1:07 pm    Post subject:
Reply with quote

Gargi,

This should suffice your requirement -

http://www.ibmmainframes.com/viewtopic.php?t=28591&highlight=count
Back to top
View user's profile Send private message
gargi koley

New User


Joined: 11 Jan 2008
Posts: 10
Location: satyam gateway,hi-tech citi,hyderabad

PostPosted: Wed Mar 12, 2008 2:27 pm    Post subject:
Reply with quote

hi murali

i am not able to open the link
can u get me the right link

thanks & regards
gargi
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Mar 12, 2008 9:36 pm    Post subject:
Reply with quote

You can use a DFSORT like the following to do what you asked for:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
    1                                  T1
    2                                  T2
    3                                  T1
    4                                  T3
    5                                  T1
    6                                  T2
/*
//SORTOUT DD SYSOUT=*
//SYSIN    DD    *
  SORT FIELDS=(40,2,CH,A)
  OUTFIL REMOVECC,NODETAIL,
    SECTIONS=(40,2,
      TRAILER3=(5:40,2,32:COUNT=(EDIT=(IIIIT))))
/*
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


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