Oninit cdi / Archive
Talk to an expert →

How to use non std delimiter

Posted in 2016

Topics: Server Administration, Migration, Import/Export & Data Conversion, Platform-Specific Issues

BEVIS KENNEDY — — source: IIUG Forums & Mailing Lists

We are using 12.10.FC5 on Linux. I have a customer that requires I unload tables using a non-standard delimiter, more specifically they are asking us to use the euro ‘€’ symbol. Presumably because some of the tables have byte and/or text columns. I've tried using dbaccess on Linux and Server Studio on Windows. Can anybody help with this?

↪ replying to BEVIS KENNEDY
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello, Bevis. You can use DELIMIDENT environment variable... Check the official document page: http://www.ibm.com/support/knowledgecenter/api/content/SSGU8G_12.1.0/com.ibm.sql r.doc/ids_sqr_233.htm?locale=en Regards. Alexandre Marini ________________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de BEVIS KENNEDY <bkennedy@utah.gov> Enviado: quarta-feira, 11 de maio de 2016 13:22:27 Para: ids@iiug.org Assunto: How to use non std delimiter [37096] We are using 12.10.FC5 on Linux. I have a customer that requires I unload tables using a non-standard delimiter, more specifically they are asking us to use the euro ‘€’ symbol. Presumably because some of the tables have byte and/or text columns. I've tried using dbaccess on Linux and Server Studio on Windows. Can anybody help with this? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to BEVIS KENNEDY
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

Use DBDELIMITER (and not DELIMIDENT; that does a different job). Or specify the delimiter in the UNLOAD syntax. On Wednesday, May 11, 2016, BEVIS KENNEDY <bkennedy@utah.gov> wrote: > We are using 12.10.FC5 on Linux. > I have a customer that requires I unload tables using a non-standard > delimiter, more specifically they are asking us to use the euro ëÄí symbol. > Presumably because some of the tables have byte and/or text columns. > I've tried using dbaccess on Linux and Server Studio on Windows. Can > anybody > help with this? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2015.1101 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --001a11463fd2dc6705053293eef2

↪ replying to Jonathan Leffler
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Yes, indeed I messed them up. Thanks, Leffler. ________________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de Jonathan Leffler <jonathan.leffler@gmail.com> Enviado: quarta-feira, 11 de maio de 2016 13:57:15 Para: ids@iiug.org Assunto: Re: How to use non std delimiter [37098] Use DBDELIMITER (and not DELIMIDENT; that does a different job). Or specify the delimiter in the UNLOAD syntax. On Wednesday, May 11, 2016, BEVIS KENNEDY <bkennedy@utah.gov> wrote: > We are using 12.10.FC5 on Linux. > I have a customer that requires I unload tables using a non-standard > delimiter, more specifically they are asking us to use the euro ëÄí symbol. > Presumably because some of the tables have byte and/or text columns. > I've tried using dbaccess on Linux and Server Studio on Windows. Can > anybody > help with this? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2015.1101 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --001a11463fd2dc6705053293eef2 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary