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

SUM option using DFSORT
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
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
 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
 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 Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Thu Sep 23, 2010 9:59 pm
 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts SCOPE PENDING option -check data DB2 2
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us