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. Are you using 'unload' ? If so, you should get trailing spaces 0% of the time. June -- june_t@hotmail.com Living on Snickers bars in San Mateo

I can't remember whether I mentioned SQLCMD in this context -- if I did, I apologize for repeating myself. SQLCMD, available from the IIUG web site, has a fixed output format which always adds trailing blanks. June Tong wrote: > 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. > > Are you using 'unload' ? If so, you should get trailing spaces 0% of > the time. On CHAR and NCHAR columns; on VARCHAR and NVARCHAR columns, the trailing blanks are significant, of course. However, I doubt that 50% of the columns are VARCHAR and the others CHAR. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>