DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skreddy2020
Participant



Joined: 13 Mar 2006
Posts: 4
Location: Hyderabad
Points: 29

Post Posted: Thu Feb 08, 2007 3:07 am Reply with quote    Back to top    

DataStage® Release: 6x
Job Type: TX
OS: Unix
Hi,
How to handle multibye char in DSTX ? Any suggestions please.....

Thnks
skreddy
janhess
Participant



Joined: 18 Sep 2003
Posts: 201
Location: UK
Points: 950

Post Posted: Thu Feb 08, 2007 10:52 am Reply with quote    Back to top    

probably by specifying the correct Item Subclass/National language/Data language in the type tree but I'm not 100% sure.
Rate this response:  
Not yet rated
skreddy2020
Participant



Joined: 13 Mar 2006
Posts: 4
Location: Hyderabad
Points: 29

Post Posted: Thu Feb 08, 2007 11:58 pm Reply with quote    Back to top    

janhess wrote:
probably by specifying the correct Item Subclass/National language/Data language in the type tree but I'm not 100% sure.

I tried and I have noticed that Mercator is treating the multi byte char as normal text when the text is being used with any of the functions. When I tried to read a sample file which has Japanese char ,the length of the text is 19 but the SIZE function returns 52.
Rate this response:  
Not yet rated
balavk
Participant



Joined: 01 Nov 2007
Posts: 2

Points: 10

Post Posted: Fri Nov 02, 2007 1:09 am Reply with quote    Back to top    

Hi

We are facing the same problem in our proj.

There are multibyte Japanese characters which are not read in source properly and giving NLS error. However single byte characters are working fine.

Pls let me know if you have found out a solution.

Thanks
Bala

[quote="skreddy2020"][quote="janhess"]probably by specifying the correct Item Subclass/National language/Data language in the type tree but I'm not 100% sure.[/quote]
I tried and I have noticed that Mercator is treating the multi byte char as normal text when the text is being used with any of the functions. When I tried to read a sample file which has Japanese char ,the length of the text is 19 but the SIZE function returns 52.[/quote]
Rate this response:  
Not yet rated
balavk
Participant



Joined: 01 Nov 2007
Posts: 2

Points: 10

Post Posted: Fri Nov 02, 2007 1:14 am Reply with quote    Back to top    

Hi

We are facing the same problem in our proj.

There are multibyte Japanese characters which are not read in source properly and giving NLS error. However single byte characters are working fine.

Pls let me know if you have found out a solution.

Thanks
Bala

[quote="skreddy2020"][quote="janhess"]probably by specifying the correct Item Subclass/National language/Data language in the type tree but I'm not 100% sure.[/quote]
I tried and I have noticed that Mercator is treating the multi byte char as normal text when the text is being used with any of the functions. When I tried to read a sample file which has Japanese char ,the length of the text is 19 but the SIZE function returns 52.[/quote]
Rate this response:  
Not yet rated
jvmerc
Participant



Joined: 02 Dec 2003
Posts: 94

Points: 812

Post Posted: Sat Nov 03, 2007 12:35 pm Reply with quote    Back to top    

I believe there used to be a japanese version or package offered. May want to see if IBM still maintains it or even offers it anymore.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours