creating a fixed width file with different header size

reshma11 · Post by **reshma11** » Mon Mar 01, 2010 1:41 pm

Need to create a fixed width file with a header record, followed by detail records and followed by a trailer record in a same file with different header size. Ex:- header record should be with of 120, detail records size should be 80 and trailer record width of 80. These all should go to same file.
Thank you.

chulett · Post by **chulett** » Mon Mar 01, 2010 2:50 pm

Build them separately and then concatenate them together afterwards in the proper order. You may also be able to build the records manually as one varchar field and make sure they write out in the proper size and format.