setting environment variable from a sequence

[ayan]

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

[chulett]

No. Create NLS_LANG as a user-defined Environment Variable in the Project and set it to $ENV. Then add it to your job and override the default value there to whatever you need it to be.

[ray.wurlod]

Does AMERICAN_AMERICA.AL32UTF8 really handle Chinese characters?

[ayan]

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.

[ray.wurlod]

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.