Converting ustring to string using codepage ASCL_MS1252

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
Arpanakhade2009
Participant
Posts: 30
Joined: Tue Sep 08, 2009 4:24 am

Converting ustring to string using codepage ASCL_MS1252

Post by Arpanakhade2009 »

Hi All,
Can you please guide me with below issue:

Below is the job populating data from Source: Oracle(Oracle Enterprise) to Target: SQL server(ODBC)
In database the metatdata is
Col1 : NVARCHAR2 (255) - > Col1 : VARCHAR (510)

The jobs prompts with the below warning
When checking operator: When binding output interface field Col1 to field Col1 : Implicit conversion from source type "ustring[max=255]" to result type "string[max=510]": Converting ustring to string using codepage ASCL_MS1252.

Thus modified code as below
Col1 : NVARCHAR2 (510) - > Col1 : NVARCHAR2 (510)

The jobs prompted with one more warning

When checking operator: When binding output interface field Col1 to field Col1 : Implicit conversion from source type "ustring[max=255]"to result type "string".

When checking operator: When binding output interface field Col1 to field Col1 : Conversion from source type "string" to result type "ustring[max=510]": Possible truncation of variable length string.

When i made the similar modification in some other job it worked but for some job it is not i am not able to figure out the reason.
Post Reply