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
$APT_ORCHHOME Error
Moderators: chulett, rschirm, roy
$APT_ORCHHOME Error
harshakumar mc
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
$APR_ORCHHOME ERROR
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
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
harshakumar mc