Re: Outputting rows in fixed length format

Try: (in dbaccess) OUTPUT TO "file.unl" SELECT col1||col2||col3||col4 FROM table; This statement concatenates cols depending on their lenghts. I think (but don't have the FM here) that you can put a USING clause if some of the cols are numeric, to force the picture of them. Another way is to unload in the "normal" way and filter thru an awk script (with printf fixed lenght format directives). Hope this helps Byte byte! -- Mario R. Canto mcanto@intec.unl.edu.ar mcanto@intec.arcride.edu.ar http://www.intec.unl.edu.ar/~mcanto Neil Truby wrote: > > I've been asked to provide an extract from an Informix table for import into > a non-Informix system. It's easy enough to provide a delimited file using > UNLOAD TO.... But the requirement is actually to provide a non-delimited, > fixed length record for each row. > > Any ideas on whether this is possible and, if so, how it might be done? > > Thanks > > Neil