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
LC_CTYPE
Moderators: chulett, rschirm, roy
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).
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).
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: