Re: unload statement - need fixed lengt

Weimin Yang wrote: }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. } You could run it as an sql statement with -> Output -> New File. It puts a space between each column, but it does keep the trailing spaces. Lesley lesley.simpson@bbc.co.uk