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



Joined: 09 Feb 2018
Posts: 1

Points: 10

Post Posted: Fri Feb 09, 2018 2:25 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,

I´m moving data from MS SQL Server 2012 to Informix 12.10 using DataStage 11.50. MS SQL has collation cp1250 and Informix running on AIX has 8859-2.

I have problem with characters which are valid for cp1250 e.g. "€" but doesn´t exists in 8859-2 code page.



These records exited with warning and not pushed to target. Source datatype is Varchar(200) and target as well Varchar(200).



Source Connertor is MS SQL Native and target is Infromix CLI (ODBC)



Any experience on this are very appreciated. Thank You.

Miro
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