Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.