Join stage warning for unicode set on Teradata column

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Rajesh Jale
Premium Member
Premium Member
Posts: 6
Joined: Fri Mar 14, 2014 2:29 am

Join stage warning for unicode set on Teradata column

Post by Rajesh Jale »

Hi,
I am using join stage to perform join operations on teradata connector and flat file. I have two columns (COL1, COL2) on teradata connector and COL1 is key column havning "EXTENDED" set as "Unicode".
COL1 Metadata is same on both Flat file and teradata connnector except "Unicode" set for teradata connector.

When I execute the job, i'm seeing following warning message when I have UNICODE set for COL1 on Teradata connector and no warning message when I remove it.

I need to read COL1 from Teradata connector with UNICODE also I want to avoid this warning. Can someone help me on this.

Warning : Join_stage: When checking operator: On input data set 1: When binding input interface field "COL1" to field "COL1": Implicit conversion from source type "ustring[max=30]" to result type "string[max=30]": Converting ustring to string using codepage ISO-8859-1.
Regards,
Rajesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Make sure that the Unicode extension is either set on all links (input links and output link) or not set on all links.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply