Re: Unload Ifx fixed-length fields

On Thu, 15 May 1997, Rob Dominguez wrote: > I need to export fixed length fields for an outside vendor with a > mainframe. I can't find anything in the documentation - but I did learn > that trailing blanks are not stripped from varchar only. > > Is there a simple way to get what I want? Or should I just write a shell > script to pipe the output through? > Informix can't UNLOAD fixed-length. Best bet is to pipe unload stream thru awk or cut. I suggest using ^ (caret) as the DELIMITER. Be sure to tell awk or cut about the delimiter. Awk has a system dependent limit of about 100 fields per record, and perhaps 4K total record length. I'm not sure about cut limits (if any). Dan +-----------------------------------------------------------------+ | Striving to be what the liberals call a "tax-cuts-for-the-rich, | | mean-spirited, intolerant, radical, religious-right, extremist" | +-----------------------------------------------------------------+