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



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

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

Postby 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.

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


Thanks & Regards,
D.Vigneshkumar
vignesh
 
Posts: 1
Joined: Fri Jul 10, 2009 9:38 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby 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?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

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

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

Homework's almost due. . . ;)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post