LC_CTYPE

[Soumyabrata]

Hi,
Can anybody help me what value to set for LC_CTYPE parameter in dsenv file?I am loading data for Czech language with NLS_LANG as "AMERICAN_AMERICA.WE8ISO8859P1".I am able to load data manually with SQL Loader,but unsuccessful while loading data with OCI stage in Datastage

[DSguru2B]

You will be able to find this info in the Install and upgrade guide. The following is directly out of the guide

If you have installed NLS, you need to edit the $DSHOME/dsenv file to
specify the locale that the server uses (this is separate from the default
locales for projects or jobs, which can be different if required). This
enables server jobs to compile correctly. Locate the following section
in dsenv:
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
Take the following steps:
1 Replace all occurrences of <langdef> with the locale used by the
server (the locale must be one of those listed when you use the
locale -a command).
2 Remove the #s at the start of the lines.
3 Stop and restart the DataStage server:
To stop the server:
$DSHOME/bin/uv -admin -stop
To start the server:
$DSHOME/bin/uv -admin -start
Ensure that you allow sufficient time between executing stop and
start commands (minimum of 30 seconds recommended).

[chulett]

Well... that would be how to set it, not what to set it to. I'd suggest a chat with your friendly neighborhood DBA man, see if they can shed any light on what it needs to be set to.

[ray.wurlod]

Try ISO8859-1. If you set this for LC_ALL you don't need to worry about the specific locale categories below it.