Sorting using DFSORT

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
siv_san
Member
Posts: 3
Joined: Fri May 11, 2012 9:19 am

Sorting using DFSORT

Post by siv_san » Fri May 11, 2012 9:25 am

I have a requirement to sort the data which is in decimal and take a maximum value in that.

Example:

3045.45666
3.45655
324.554547
3334.4455
3333.44578
3214.224574
4578.1124578

Now, how do I sort this? I have tried different ways using DFSORT but didn't get the expected result. Any help would be appreciated
Regards,
San

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Fri May 11, 2012 10:47 am

why not try posting in the DFSort part of the forum? What ways have you tried? Have you tried SFF for example?
Regards
Nic

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Fri May 11, 2012 10:42 pm

San,

You haven't given a clear enough explanation of your requirement for anyone to help you.

You show values with different numbers of decimal places ranging from 4 to 7. These must be "normalized" to be sorted. But you haven't told us the minimum or maximum number of decimal places your values can have (is it min=4 and max=7 or something else?).

You also haven't told us the maximum length of your values (the maximum length you show is 12 - is that the actual max?).

You don't need to SORT to get the maximum value. Do you need to SORT anyway (to get the values in sorted order)? What exactly do you want your output to look like?

You need to do a better job of explaining your requirement before anyone can help you.
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

siv_san
Member
Posts: 3
Joined: Fri May 11, 2012 9:19 am

Post by siv_san » Tue May 15, 2012 8:58 am

Hi Frank,

Thanks for your response and I am sorry as my explanation is not very clear.

The max length of my value is 12 and the no of decimal values which I want is 4. My requirement is I want to take the max. no from the list of values which I mentioned above.
Hope it is clear now!!!
Regards,
San

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others