MVSFORUMS.com

waves · Beginner Joined: 09 Nov 2006 Posts: 35 Topics: 12

The following is my requirement:

i need to sort the input file based on two fields such as SSN(social security number) in ascending order and the Timestamp on descending order. please help in this regard.

SSN-- X(9)
Timestamp--X(14)

dbzTHEdinosauer · Posted: Sat Oct 06, 2007 4:19 am Post subject: SORT FIELDS syntax

what location within the record are the two fields?

SORT FIELDS=(pos,length,type,order,pos,len,type,order)

order is A for decending and D for decending.

so, if ssn is in position 11 and timestamp is in position 87:
SORT FIELDS=(11,9,CH,A,87,14,CH,D)

a better title would have been: syntax for SORT FIELDS.

no one will beable to search the forum and find your post as an example of SORT FIELDS syntax.
_________________
Dick Brenholtz
American living in Varel, Germany

waves · Beginner Joined: 09 Nov 2006 Posts: 35 Topics: 12

thanks for ur valuable reply.

SSN number is at 1st position

Time stamp is at 260th position

kolusu · Posted: Sat Oct 06, 2007 9:16 am Post subject:

waves,
Try this

Frank Yaeger · Posted: Sat Oct 06, 2007 1:53 pm Post subject:

waves,

This is pretty basic stuff. If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

waves · Beginner Joined: 09 Nov 2006 Posts: 35 Topics: 12

Thanks a lot Kolusu and Frank.

I need to do the same sort in COBOL program.

i have an input file which has the SSN number, First name, Last name, Timestamp etc. as some of its columns.

i need to sort the input file so that i get the latest record from the input file based on the Timestamp.

In this case, the first sort was done on the SSN number,first name and last name in Ascending order and then the Timestamp in the descending order.

the second sort was done on the SSN Number, First name and Last name, so that all the duplicates will be removed giving SUM FIELDS = NONE.

the final out put file will contain the Latest record. These things i have done in thru JCL.

the same has to be done in the COBOL Program. please i need help how to do the same in COBOL.

please correct me if i'm wrong.

We are using SYNCSORT Product.

Thanks in Advance.

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

waves,

You can do the same in COBOL. Refer the quick manuals link to get a hold of sorting in COBOL.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3PG10/1.12?DT=20020923143836
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)