doing unloads with trim function ?

Posted in 2008

Topics: Migration, Import/Export & Data Conversion

Floyd Wellershaus — Tue, 2 Dec 2008 15:38:26 -0600 (CST) — source: Usenet: comp.databases.informix

Does anyone know if there is any environment variable or something that can cause unloads and or exports to trim fields of excess spaces ? Thanks, floyd

↪ replying to Floyd Wellershaus

Ian Goddard — Tue, 02 Dec 2008 22:20:47 +0000 — source: Usenet: comp.databases.informix

Floyd Wellershaus wrote: > Does anyone know if there is any environment variable or something that > can cause unloads and or exports to trim fields of excess spaces ? > > Thanks, > floyd > Dunno but I've always used a sed script. -- Ian Hotmail is for spammers. Real mail address is igoddard at nildram co uk

↪ replying to Ian Goddard

Keith Simmons — Wed, 3 Dec 2008 09:27:43 +0000 — source: Usenet: comp.databases.informix

2008/12/2 Ian Goddard <goddai01@hotmail.co.uk>: > Floyd Wellershaus wrote: >> Does anyone know if there is any environment variable or something that >> can cause unloads and or exports to trim fields of excess spaces ? >> >> Thanks, >> floyd >> > > Dunno but I've always used a sed script. > > -- > Ian > > Hotmail is for spammers. Real mail address is igoddard > at nildram co uk > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Floyd What leads you to believe the space is not trimmed. On IDS9.4

↪ replying to Floyd Wellershaus

scottishpoet — Wed, 3 Dec 2008 09:23:19 -0800 (PST) — source: Usenet: comp.databases.informix

On Dec 2, 9:38 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Does anyone know if there is any environment variable or something that can cause unloads and or exports to trim fields of excess spaces ? > > Thanks, > floyd i understood space at the end of the character string was removed Other spaces at the beginning and in the middle of the text are needed for the import of the data or you would end up with different data from that which you exported, so they remain

↪ replying to scottishpoet

Fernando Nunes — Wed, 03 Dec 2008 23:27:59 +0000 — source: Usenet: comp.databases.informix

scottishpoet wrote: > On Dec 2, 9:38 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: >> Does anyone know if there is any environment variable or something that can cause unloads and or exports to trim fields of excess spaces ? >> >> Thanks, >> floyd > > i understood space at the end of the character string was removed > > Other spaces at the beginning and in the middle of the text are needed > for the import of the data or you would end up with different data > from that which you exported, so they remain Spaces at the end of CHAR are not put on the unload file. Spaces at the end of VARCHAR are put on the unload file. Empty strings and nulls are particular cases. Everything in the unload/load works with the idea that you will get exacly what you had in the source. This may not be friendly when people use "simple" unload files to move data across applications. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...