Datastage Character Set

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Datastage Character Set

Post by cosec »

Appreciate your advice on the following:

1. How do I find out which character set is being used ?
2. How to change the character set to UTF-8?
3. Can the character set being changed for a particular job only ?

Thanks,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you do not have NLS enabled, the internal character set is ASCII.
If you do have NLS enabled, the internal character set is UV-UTF8.
Neither of these is negotiable.
What you can do, if you have NLS enabled, is to map between any other encoding used externally to DataStage into or out of the internal (UV-UTF8) character set.

Note that this answer is only correct for server jobs. A different mechanism is used in parallel jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply