How to copy only one record after sorting to SORTOUT.

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
esmayeel_s
Member
Posts: 3
Joined: Thu Dec 30, 2010 11:30 am

How to copy only one record after sorting to SORTOUT.

Post by esmayeel_s » Wed Jan 12, 2011 2:10 pm

Hi All,

I have a sort card as below.

INCLUDE COND=(1,13,CH,EQ,C'abc-xyz-data')
SORT FIELDS=(15,4,CH,D,19,2,CH,D,21,2,CH,D,24,6,CH,D)
SORT FIELDS=COPY

It will pickup the rows which contains charector 'abc-xyz-data' in 1 to 13th position and then it will sort the as per the above condition and finally it will write all records to SORTOUT file.

After sorting i want only first record to placed in the SORTOUT. How it can be achived.

Please suggest.

Thanks
Husen

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Jan 12, 2011 2:29 pm

Use STOPAFT=1, along with your SORT statements.
Regards,
Anuj

esmayeel_s
Member
Posts: 3
Joined: Thu Dec 30, 2010 11:30 am

Post by esmayeel_s » Wed Jan 12, 2011 4:46 pm

I have tried this option before pasting the Query, but it is copying only one record without sorting.

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

Post by Frank Yaeger » Wed Jan 12, 2011 10:56 pm

STOPAFT is processed before sorting so it won't do what you want.

OUTFIL is processed after sorting so ENDREC=1 will do what you want.

Code: Select all

  INCLUDE COND=(1,13,CH,EQ,C'abc-xyz-data') 
  SORT FIELDS=(15,4,CH,D,19,2,CH,D,21,2,CH,D,24,6,CH,D) 
  OUTFIL ENDREC=1
If you have the Oct, 2010 DFSORT PTF, ACCEPT=1 will also work.

For more information on the order of processing for various DFSORT functions, see:

http://publibz.boulder.ibm.com/cgi-bin/ ... FIGSTMTSEQ
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

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Jan 13, 2011 5:46 pm

Thanks Frank. I had my lesson for the day.

Sorry for the wrong information, Husen.

have a good one, :)
Regards,
Anuj

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