Page 1 of 1
Producing files in UTF8 format
Posted: Mon Oct 11, 2004 12:26 am
by dhletl
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
Posted: Tue Oct 12, 2004 5:28 am
by Eric
If you install DataStage with NLS then you can choose the MAP used when reading/writing data as one of the stage options.
Posted: Wed Oct 13, 2004 3:24 am
by dhletl
How do I make sure that the DataStage installation is done with NLS?
(I do not have admin rights on the DataStage installed on our server.)
Thanks
Nitin
[/img][/list][/list]
Posted: Wed Oct 13, 2004 10:11 am
by Eric
I guess you should speak to your server admin
Posted: Wed Oct 13, 2004 3:22 pm
by ray.wurlod
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.