Reading Japaneese data by ETL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Reading Japaneese data by ETL
In our project we have data source in japaneese language.we are not able to read records properly.Can anybody tell how this problem can be resolved. Also Please let us know, is there any way to read the japanese data from source & load it to target table in Japanese.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You must have NLS installed and enabled.
You must be aware of how the Japanese characters are encoded - there are at least fifteen different ways.
This map (for example one of the SHIFT-JIS maps) must have been loaded - use the Administrator client to get maps loaded.
Then you set this map on the stage that is reading from source and the stage that is writing to target.
The maps convert from the external encoding (whatever it is) to a UV-UTF8 encoding of Unicode used within DataStage.
There is a DataStage NLS manual among your documentation that will help you through the various processes. Manuals and readme files are also available in Japanese.
You must be aware of how the Japanese characters are encoded - there are at least fifteen different ways.
This map (for example one of the SHIFT-JIS maps) must have been loaded - use the Administrator client to get maps loaded.
Then you set this map on the stage that is reading from source and the stage that is writing to target.
The maps convert from the external encoding (whatever it is) to a UV-UTF8 encoding of Unicode used within DataStage.
There is a DataStage NLS manual among your documentation that will help you through the various processes. Manuals and readme files are also available in Japanese.
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.