DSXchange

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,

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.