Page 1 of 1

creating a fixed width file with different header size

Posted: Mon Mar 01, 2010 1:41 pm
by reshma11
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.

Posted: Mon Mar 01, 2010 2:50 pm
by chulett
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.