How to add New NLS Map in the Datastage Server?

dwuser · Post by **dwuser** » Mon May 14, 2007 6:08 pm

Hi,

Our Target database is in UTF-16 format.

When writing to a database, we like to convert data to UTF-16 format. But in the Available/ show all Maps list there was no UTF-16 format.

Is there a way to add UTF-16 code sheet to the server and make available in the list?

Any inputs or document on this would be greatly appreciated.

Thanks,
Dwuser.

ray.wurlod · Post by **ray.wurlod** » Mon May 14, 2007 7:00 pm

There is a manual called DataStage NLS in the standard manual set. This takes you through the process of creating a map. Make sure that every mapping you create is round-trip-capable.

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 12:46 am

In the NLS.ADMIN menu choose Mappings then Tables then Create. This creates an entry in NLS.MAP.TABLES table. Enter the name of the table (for example UTF-16). It then prompts You may copy an exsting record to form the basis of the new one whereupon you can enter the name of a compatible map (or none - enter Q to quit). You are then in the line editor ED and ready to enter pairs of code points - one from UTF-16 and one from Unicode, as hexadecimal digits.

Plan ahead.