Writing the WVARCHAR column into a VARCHAR database column

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Locked
ujala
Participant
Posts: 45
Joined: Mon Jun 21, 2010 2:51 pm
Location: Chennai

Writing the WVARCHAR column into a VARCHAR database column

Post by ujala »

Hi all,
I created job that extracts the data from DB2 and loads into Mysql using IBM Data Direct Driver.After successfully completion ,i got the following error message "Writing the WVARCHAR column ... into a VARCHAR database column can cause data loss or corruption due to character set conversions.".
Please give solution for this issue
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No need to post this again, your original post is here in the PX forum.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Locked