Re: unloading trailing spaces

-----Original Message----- From: Wolfgang Zager <zager@compuserve.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: 07 '''''''' 2000 '. 14:10 Subject: Re: unloading trailing spaces >"Dan, Rebecca, Cody Djuric" wrote: >> >> Informix gurus: >> >> I am trying to modify a text file by loading the file into an informix >> database, performing updates in SQL through reference tables, and >> unloading to an un-delimited text file. The problem I am running into >> is that the trailing spaces (which I want included in the unload) are >> only unloading 50% of the time. I am using a char[24] field type. Can >> anyone please offer any suggestions on how to get the trailing spaces to >> unload 100% of the time. >> >> Thanks >> -Dan > >Hello Dan, > >if You are working on a UNIX-Machine the is an easy way. >Use a char(25) field and put a character, You don't use >in Your text on place 25 (e.g. "@"). > >Back on unix-shell You can do a >"cat orgfile | tr -d @ > newfile", >which will wipe off the "@". > >Wolfgang Hi! Use a VARCHAR(24) field, Informix save trailing spaces for VARCHAR type when unloading. Best regards, Danail.