DB2 characters changed to questions marks when using "Remote Actions from different repository"

Document ID : KB000099943
Last Modified Date : 02/06/2018
Show Technical Document Details
Issue:
3 environments are used for TDM (dev, test, prod).  Artifacts need to be moved depending on the stage they are on. When using the Remote Actions from different repository option to move data pools from one environment to the next one, special characters are changed to question marks, creating bad data when publishing.  Special characters are BINARY characters.  How can we accomplish this?
Environment:
TDM 4.4 
Resolution:
Although a pseudo script was provided and an actual SQL script was attempted to be created, it was decided to resolve the issue with a code fix. This is resolved with GTDataMakerPB-4.5.0.50.zip.  Please contact CA Support to see this is available in a GA after May 31, 2018.
Additional Information:

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html