Re: DB_LOCALE error

Posted in 2003

Tsutomu Ogiwara — Tue, 24 Jun 2003 17:28:01 +0900 — source: Usenet: comp.databases.informix

Hi Emilio. Try the following. database sysmaster; select * from sysdbslocale; Probably DB_LOCALE of your selecting database and remote database is different. If you are setting DB_LOCALE, try as below. C-Shell or TCSH setenv DB_LOCALE .... B-Shell or K-shell DB_LOCALE=...export DB_LOCALE HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Emilio A. Garza Reyes" <egarza@citi.com.mx> >To: <informix-list@iiug.org> >Subject: DB_LOCALE error >Date: Mon, 23 Jun 2003 15:56:03 -0500 > >Hi Guys, > >IDS 9.21 on AIX >I'm getting this error when i run a query from one informixserver to >another: > > 23197: Database locale information mismatch> >i.e. : select * from stxdemo@apmstxinst1:trtsrd_rec > > >Do you have any ideas about it? > >There is no DB_LOCALE enviroment value on both informixserver's ... how >can i set it? >wich one is the right value? where i can get it ? > > >sending to informix-list _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail sending to informix-list