How to export to Fixed Field ASCII format with header and trailer records?
Posted on 2007-11-27
I have a vendor who is requesting we export our data in an "ASCII fixed field, fixed length" format with header and trailer records.
I've never dealt with header or trailer records before and am not clear how I'd insert these.
First, how would I export in this format, and what kind of query would I need to insert these "header" and "trailer" records? By the way, the columns requested in the header and trailer records do not match the number of columns in the "Detail" records.