Hi,
I have a job that loads chinese data in oracle 10g db.For the loading to happen correctly I need to set the NLS_LANG value in datastage box to AMERICAN_AMERICA.AL32UTF8.I know that it can be done in a script i.e I set NLS_LANG for that session and call the job using DSJOB.But is there a way to do it within a sequence ? If I set NLS_LANG in a command stage and then run the job (within a sequence),will it work?Will the session be same for both command stage and job activity stage?
Regards,
Ayan
setting environment variable from a sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ok,will set it in Administrator. Ray,it works.I was able to load it in oracle db(10G).Only problem I faced is that ,while querying toad I wsa not able to see the chinese data.But after using sql developer/isqlplus,data was getting correctly displayed.Don't know whether it's a toad problem or any extra configuration is needed.
Ayan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My guess is that it's a limitation of TOAD.
Which, to be fair, was never originally written with the intention of displaying anything but ASCII characters. Hence the existence of derivatives.
Which, to be fair, was never originally written with the intention of displaying anything but ASCII characters. Hence the existence of derivatives.
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.