Producing files in UTF8 format

dhletl · Post by **dhletl** » Mon Oct 11, 2004 12:26 am

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

Eric · Post by **Eric** » Tue Oct 12, 2004 5:28 am

If you install DataStage with NLS then you can choose the MAP used when reading/writing data as one of the stage options.

dhletl · Post by **dhletl** » Wed Oct 13, 2004 3:24 am

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]

Eric · Post by **Eric** » Wed Oct 13, 2004 10:11 am

I guess you should speak to your server admin

ray.wurlod · Post by **ray.wurlod** » Wed Oct 13, 2004 3:22 pm

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.