Re: blanks in LOAD-file

Posted in 1998

WF Software — 21 Aug 1998 17:33:33 GMT — source: Informix-list mailing list archive (1991-1998)

In article <1998082108491201.EAA06281@ladder01.news.aol.com>, prozessdv@aol.com (ProzessDV) wrote: > I want to migrate from a DDB/4 database to OWS 7.22 on SCO 5.0.4. > Unfortunately, when I use LOAD to insert data into the tables LOAD pads > char-columns with blanks. Does anybody know how to suppress this > filling with > blanks? > > Thanks in advance for your help, > > Pascal > > Don't worry about it, Informix will always pad char, you could use varchar if you are worried about it. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #