Format records using sort

c_mayur · New User Joined: 21 Jul 2007 Posts: 4 Location: India

My file looks like this

Bill Woodger · Posted: Tue Jun 17, 2014 12:04 am

It is a simple BUILD on INREC. Specify the start/length of each input field, in the order you want them on the output. Done.

What is the problem you've had? Did you try to use OVERLAY instead of BUILD? You'd need an extra field. If that means extending the record, you'll have the equivalent of a BUILD anyway, with extra messing about.

Abid Hasan · New User Joined: 25 Mar 2013 Posts: 88 Location: India

Hello,

Please read on OUTFIL in DFSORT, this link gives ample examples on the usage of the same; and here is the link for the DFSORT Application Programming Guide which should help you work out the parameter definitions.
This task can be easily achieved by reformatting records using OUTFIL.

Bill Woodger · Posted: Tue Jun 17, 2014 1:02 am

The records could be reformatted in INREC, OUTREC or OUTFIL. If OUTREC or OUTFIL aren't otherwise required, I always use INREC.

Abid Hasan · New User Joined: 25 Mar 2013 Posts: 88 Location: India

Completely agree Bill, INREC being the better choice, because of the DFSORT processing hierarchy.