Hi,
How do we generate files data after ETL processing in UTF8 format?
Is this feature provided in DataStage PX version 7.0 and above?
If so, which passive stage needs to be used?
Pls provide details.
Thanks,
Nitin
Producing files in UTF8 format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can determine whether national language support (NLS) is enabled or not easily; every passive stage link properties window will include an NLS tab.
Alternately, you could examine the uvconfig file in the DataStage "home" directory ($DSHOME) and look for the NLSMODE parameter. If it's present, and set to 1, then NLS is enabled.
Without NLS, DataStage uses a single-byte character set internally. With NLS, DataStage uses a UTF-8 encoding of Unicode internally. Note that there are many different UTF-8 encodings; DataStage's is idiosyncratic in that it preserves single-byte dynamic array delimiter characters and its internal representation of NULL.
Alternately, you could examine the uvconfig file in the DataStage "home" directory ($DSHOME) and look for the NLSMODE parameter. If it's present, and set to 1, then NLS is enabled.
Without NLS, DataStage uses a single-byte character set internally. With NLS, DataStage uses a UTF-8 encoding of Unicode internally. Note that there are many different UTF-8 encodings; DataStage's is idiosyncratic in that it preserves single-byte dynamic array delimiter characters and its internal representation of NULL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.