Re: unload statement - need fixed length fields for export from 4.1

Ian Goddard wrote: } } 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? } > } > Any suggestions would be appreciated. } } How about an Ace or 4GL report? } } Ian You can use tab ' ' as delimiter of the unload file. You can get a fix length column file except the last column. But you can't set the length of the columns. I think the best way is to write a report file. -- Weimin Yang wyang@aerotek.com (914)640-1050