IBM Mainframe Forum

by **vignesh** » Fri Jul 10, 2009 9:56 pm

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.

Select all

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

Thanks & Regards,
D.Vigneshkumar

by **Frank Yaeger** » Fri Jul 10, 2009 10:17 pm

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?

by **dick scherrer** » Sat Jul 11, 2009 1:27 am

Homework's almost due. . .

d

IBM Mainframe Forum

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

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

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

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