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
 

 

SUM option using DFSORT

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

New User


Joined: 18 Jan 2008
Posts: 30
Location: mumbai

PostPosted: Thu Sep 23, 2010 2:06 pm    Post subject: SUM option using DFSORT
Reply with quote

I have the sort card as below

Code:

  SORT FIELDS=(43,6,CH,A)
  SUM FIELDS=(1,6,ZD)   


I/p (sortin)
000078~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000789~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000583~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000003~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000003~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000003~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000003~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000203~0029~0004~0000~0000~0000~0000~0000~100923~013742~
000003~0029~0004~0000~0000~0000~0000~0000~100923~013742~



O/p am getting is
00166H~0029~0004~0000~0000~0000~0000~0000~100923~013742~


But i want the O/p to be
001668~0029~0004~0000~0000~0000~0000~0000~100923~013742~

Please suggest ....
Back to top
View user's profile Send private message

bipinpeter

Active User


Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India

PostPosted: Thu Sep 23, 2010 4:46 pm    Post subject:
Reply with quote

Can you try like this

Code:

  SUM FIELDS=(1,6,ZDF)
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: Thu Sep 23, 2010 9:59 pm    Post subject:
Reply with quote

Hac,

You need to use:

Code:

    OPTION ZDPRINT


Bipin Peter,

Code:

  SUM FIELDS=(1,6,ZDF)


is invalid syntax. Please try your "solutions" before posting them.
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 DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am


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