Datastage 11.5 RCP Oracle 12c Varchar field issue.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Mon Apr 12, 2010 3:42 pm
- Location: Minneapolis
- Contact:
Hi Criag,
Thanks for the reply.
Yes in the schema file we can define it. Instead of "string" as the datatype if we define the datatype as "ustring", that will just act as extended "Unicode" for the varchar.
But if we have 200 staging tables, i will have to define 200 schema files.
And if i have to use the schema file, than i will have to go with stages like sequential file and i am not sure if sequential file stage will be handle the history load.
I am guessing it has to do more with the NLS, but just don't know what NLS setting i have to use.
Thanks for the reply.
Yes in the schema file we can define it. Instead of "string" as the datatype if we define the datatype as "ustring", that will just act as extended "Unicode" for the varchar.
But if we have 200 staging tables, i will have to define 200 schema files.
And if i have to use the schema file, than i will have to go with stages like sequential file and i am not sure if sequential file stage will be handle the history load.
I am guessing it has to do more with the NLS, but just don't know what NLS setting i have to use.
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Check if the schema used at run time have all fields as ustring, if yes then add an environment variable to the DS project name it "NLS_LANG" and set it to "AMERICAN_AMERICA.WE8MSWIN1252", add it to the DS job
Let us know how it goes
Let us know how it goes
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Premium Member
- Posts: 32
- Joined: Mon Apr 12, 2010 3:42 pm
- Location: Minneapolis
- Contact:
Hi Julio,
Thanks for the suggestion, I did incorporate the same and it did work.
Added NLS_LANG to user defined environmental variables in DS Admin Client. Used the parameter in the job with the value set to "AMERICAN_AMERICA.WE8MSWIN1252" and ran the job. I see a perfect match between source and target data.
Thanks for the suggestion, I did incorporate the same and it did work.
Added NLS_LANG to user defined environmental variables in DS Admin Client. Used the parameter in the job with the value set to "AMERICAN_AMERICA.WE8MSWIN1252" and ran the job. I see a perfect match between source and target data.