Unicode Property at Project Level

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nk7574
Participant
Posts: 2
Joined: Tue Sep 26, 2017 1:28 pm

Unicode Property at Project Level

Post by nk7574 »

Hi,

I am receiving special characters from source system, i have incorporated "Unicode" for all the varchar columns in the source stage and continued it till target. With this i am able to bring in the special characters. However my project has 200 jobs where this change needs to be implemented. Its a bit effort to assign the columns to unicode in all 200 jobs.

Is there a way where i can assign the Unicode extension to all varchar columns at project level ?

Thanks,
Naresh
k.nani
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

I believe that the only option at that point -after importing the metadata to the DS jobs- is manually changing the property to Unicode or changing the type to NVarchar/NChar

Yo could try hacking a dsx export file and the reimport but that could become messy easily
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
nk7574
Participant
Posts: 2
Joined: Tue Sep 26, 2017 1:28 pm

Post by nk7574 »

Thank You !!
k.nani
Post Reply