Re: Pls Help ... Urgent

??? wrote: > > Hello Gurus ... > I had tried to do some processes and then unload it to a file. > I can't use the unload command because i have to filled up all the > values in a given column. > For example : > cost DECIMAL(9,2) > > If the value of cost is 1 then the result I wish to see is > 0000001.00 > > Fine ... I can't do this using the unload. So I use a report to unload > everything (formatted as above). > Everything seems fine but at the end of the report, there are many > unwanted spaces. Is it by default Informix put some spaces at the end > of the report ? If you are referring to an ace or 4gl report, then the number of lines will be padded to the PAGE LENGTH. If you haven't specified a PAGE LENGTH in your OUTPUT section, then it will default to 66. Try setting it to one (1). If you still have problems, then try using a filter on the resultant file to get rid of blank lines. Something like: sed -e "s,^$,," my_file >new_file Or send your report to a PIPE with the above command. ;-) Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+