sort the input file excluding the trailer record

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

Moderators: Frank Yaeger, Moderator Group

mothukuri
Member
Posts: 9
Joined: Tue Oct 06, 2009 3:38 pm

Post by mothukuri » Tue Oct 13, 2009 2:11 pm

Hey Frank, I have tried with the INREC you mentioned and it worked. Also removed the BLKSIZE from the DCB, it took BLKSIZE=27920 and have removed NODETAIL from OUTFIL as the data is been replaced with the trailer record. Thanks a lot :)

I have a question in the INREC code below:

Code: Select all

INREC FIELDS=(1:1,3,4:4,19,23:23,4,27:116,19,80:X) 
what does 80:X indicate in the end? X is for space as I know and is 80 the column number of the SORTOUT file from where spaces are filler till the end?

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

Post by Frank Yaeger » Tue Oct 13, 2009 8:22 pm

80:X fills in spaces from the last specified output position up to and including position 80. In your case, the last specified position is for 27:116,19 which runs up to output position 45, so blanks are filled in from output positions 46-80. This also sets the SORTOUT LRECL to 80.
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

mothukuri
Member
Posts: 9
Joined: Tue Oct 06, 2009 3:38 pm

Post by mothukuri » Wed Oct 14, 2009 6:19 pm

Great! Thanks a tonn Frank. Have a good one.

academyindia4

Topic deleted by Admin

Post by academyindia4 » Mon Jan 25, 2016 10:21 pm

<< Content deleted By Admin >>

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