Page 1 of 1

To sort a ps file and to add the fields of duplicates

PostPosted: Fri Jul 10, 2009 9:56 pm
by vignesh
Dear Sir/Madam,
I need a jcl solution to add the scores of the players and to delete the duplicates after adding the score usng sort utility.It would be very helpful for me if you provide the solution as soon as possible.The details are given below.

playerId      name          country      match         score
   7          sachin        india        ind vs pak      100
   7          sachin        india        ind vs sri      100


Thanks & Regards,
D.Vigneshkumar

Re: To sort a ps file and to add the fields of duplicates

PostPosted: Fri Jul 10, 2009 10:17 pm
by Frank Yaeger
It would be very helpful for me if you provide the solution as soon as possible.The details are given below.


Interesting. You want a solution as soon as possible, but you can't be bothered to take the time to explain clearly what you want to do.

You haven't given any details - you've just shown a couple of records. Showing a couple of input records without even showing the expected output records is not "giving the details".

Show an example of the input records for all cases and what you expect for output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of each relevant field.

delete the duplicates


Which field or fields do you want to use to determine duplicates?

Re: To sort a ps file and to add the fields of duplicates

PostPosted: Sat Jul 11, 2009 1:27 am
by dick scherrer
Homework's almost due. . . ;)

d