DSXchange

Hi All,

Running the Load method job using Oracle Enterprise stage.

Set values:
NLS_LANG=AMERICAN_AMERICA.UTF8

Error Message:
main_program: An NLS character map <ISO8859-1> is specified, but no entry was found in $APT_ORCHHOME/etc/oracle_cs.txt.

The entries in oracl_cs.txt are
UTF-8 UTF8
UTF-16 AL16UTF16
ASCL_ISO8859-1 WE8ISO8859P1
ISO-8859-1 WE8ISO8859P1
ASCL_MS1252 WE8ISO8859P1
EUC-JP JA16EUC
ASCL_JPN-EUC JA16EUC
ASCL_JPN-SJIS JA16SJIS
Shift_JIS JA16SJIS
US-ASCII US7ASCII
ASCL_ASCII US7ASCII

Please let me do i need to add one more entry or is there any way of setting it?

Thanks,
MCH

"ISO8859-1" and "ISO-8859-1" are not the same string. You probably need to copy the ISO8859 entry in oracle_cs.txt and insert the hyphen, so that ISO-8859-1 is also mapped to the NLS_LANG value WE8ISO8859P1.

Thanks for response :D

Entry:

ISO8859-1 WE8ISO8859P1 in oracle_cs.txt

Is this right??

with regards,
MCH

Hi,

It would be great if you just give me the document name the ascential datastage provides...to refer the creation of mapping file..

thanks
MCH

mc_harsha wrote:Thanks for response :D

Entry:

ISO8859-1 WE8ISO8859P1 in oracle_cs.txt

Is this right??

with regards,
MCH