Page 1 of 1

sorting trailer to header

Posted: Wed Feb 15, 2012 2:20 pm
by bernix
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?

Posted: Wed Feb 15, 2012 11:21 pm
by Frank Yaeger
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?

Posted: Thu Feb 16, 2012 4:46 pm
by bernix
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