sorting trailer to header

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
bernix
Member
Posts: 21
Joined: Tue Oct 28, 2008 8:32 pm
Location: Vienna, Austria

sorting trailer to header

Post by bernix » Wed Feb 15, 2012 2:20 pm

hi,

i have a file with a trailer record that i'd like to have as header record

input:
aaa
bbb
ccc
trailer

ouput:
trailer
aaa
bbb
ccc

is this possible in one step?

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 Feb 15, 2012 11:21 pm

Is there anything that identifies the trailer record (e.g. 'T' in position 1) other than it being the last record in the file?

What is the RECFM and LRECL of your input file?
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

bernix
Member
Posts: 21
Joined: Tue Oct 28, 2008 8:32 pm
Location: Vienna, Austria

Post by bernix » Thu Feb 16, 2012 4:46 pm

yes there is an identifier, file is variable. i found a solution:

Code: Select all

  INREC IFTHEN=(WHEN=(5,7,CH,EQ,C'XXXXXXX'),BUILD=(1,4,C'00000000',5)),
      IFTHEN=(WHEN=(5,7,CH,NE,C'XXXXXXX'),BUILD=(1,4,SEQNUM,8,ZD,5)) 
  SORT FIELDS=(5,8,CH,A)                                               
  OUTREC BUILD=(1,4,13)                 
i didnt find a solution without identifying the trailer record, just the last record in the file.

i am on holiday and i will review further posts following my return on Feb 24th

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