Oninit cdi / Archive
Talk to an expert →

How to use non std delimiter

Posted in 2016

Summary

Bevis Kennedy needed to unload tables with a non-standard delimiter (the euro symbol) on Informix 12.10.FC5. Alexandre Marini suggested DELIMIDENT, but Jonathan Leffler corrected that DBDELIMITER is the right variable, or the delimiter can be given in the UNLOAD statement. Marini acknowledged the mistake. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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