Re: unload statement - need fixed lengt

even a simple "select * from table_name" to an output file will give you the fixed length (corres. width of the individual cols) output Vj Lesley Simpson-ITS wrote: } } 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