i have two logins
patqa1
informix

patqa1 is in informix group

Now i am after executing env file for informix i am executin command set INFORMIXDIR=/usr/informix/9.40.UC1; /usr/informix/9.40.UC1/bin/dbschema -v

and error coming is
set INFOMIXDIR=/usr/informix/9.40.UC1; /usr/informix/9.40.UC1/bin/dbschema -v

I am executing this in "csh" not in "ksh"

everything is working fine in "ksh

my env command gives following output

EDITOR=vi
LOGNAME=informix
GWSOURCE=telnet
USER=informix
SHELL=/bin/csh
HOME=/usr/informix
INFORMIXDIR=/usr/informix/9.40.UC1
TERM=xterm
ONCONFIG=onconfig.butane940
PWD=/usr/informix/9.40.UC1
shell=/bin/csh
ENV=/usr/informix/.kshrc
INFORMIXSERVER=butane940

Help for this error message says that you need to set CLIENT_LOCALE and DB_LOCALE
I have set these variables to

set CLIENT_LOCALE=english_us.8859
set DB_LOCALE=en_US.CP1252

still it is not working ?

Or this is the problem for Cshell

Can any one help ?

Hi,


Remember that in csh define variables is:
setenv DB_LOCALE en_US.CP1252 and not set DB_LOCALE=en_US.CP1252

Gustavo.

Hi i am still getting same error.Can you have any thoughts on it.

% setenv PATH $INFORMIXDIR/bin
% onstat -l
GLS initialization failed, error -23101
% setenv
TERM=vt220
GWSOURCE=telnet
HOME=/apps2/patqa1
SHELL=/usr/bin/csh
USER=patqa1
LOGNAME=patqa1
PATH=/usr/informix/9.40.UC1/bin
SHLVL=1
INFORMIXDIR=/usr/informix/9.40.UC1
ONCONFIG=onconfig.butane940
INFORMIXSERVER=butane940
CLIENT_LOCALE=english_us.8859
DB_LOCALE=en_US.CP1252
% /usr/informix/9.40.UC1/bin/dbschema -v
-23101 Unable to load locale categories.
% setenv INFORMIXDIR /usr/informix/9.40.UC1;/usr/informix/9.40.UC1/bin/dbschema -v
-23101 Unable to load locale categories.
%