How to use Sort Utlity for a variable record



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

How to use Sort Utlity for a variable record

Postby shaishav » Thu Sep 03, 2015 5:36 pm

Hi,

I am Having a file containing few column of records like wise:
|830001|+10000|-9000.00
|830002|+100|-900.00
|830003|+12|-90.00
|830004|+0.00|+0.00


I need to sum the values using Sort Utility between 2nd and 3rd pipe delimeter(like 10000+100+12+0),also record after 3rd pipe(-9000-900-90+0) and move them into another ourput file and display the total value as
Total 1:sum of reocrds between 2nd and 3rd pipe delimeter
Total 2:sum of records after 3rd Pipe delimeter

Please Help.
shaishav
 
Posts: 2
Joined: Thu Sep 03, 2015 4:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to use Sort Utlity for a variable record

Postby NicC » Thu Sep 03, 2015 6:56 pm

Are you trying to do this within a COBOL program (you posted in the COBOL part of the forum) or by using one of the Sort utilities (which one - DFSort or Syncsort)?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to use Sort Utlity for a variable record

Postby shaishav » Fri Sep 04, 2015 10:56 am

Sorry to post it in cobol Forum, no i am not doing it with cobol i need to do it with dfsort.
shaishav
 
Posts: 2
Joined: Thu Sep 03, 2015 4:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to use Sort Utlity for a variable record

Postby NicC » Fri Sep 04, 2015 2:28 pm

You need to describe your input dataset (RECFM, LRECL) and provide representative sample data (are there different record types, can there be duplicates, etc) and your expected output from the sample data along with the rules for getting from input to output. You should also use the code tags when presenting data, JCL, messages etc from the screen. Look around the forum on how to use the code tags (use the Postreply button instead of the QuickReply box.

I have moved the topic and coded your data.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post