DSXchange

Dear Experts

I am loading the UTF-8 format flat files in to oracle tables and all the files are loading fine including the special characters except one file.

I have the following warning message while loading it.

Column_Import_11,0: Invalid character(s) ([x80]) found converting string (code point(s): klant geeft aan dat [x80] per betaald ) from codepage UTF-8 to Unicode, substituting.

Please help why is this warning coming up......

Many Thanks

0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file?

ray.wurlod wrote:0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file? ...

Thanks for the reply Ray, I exactly I should check it ?

No idea, because it's not my file.

ray.wurlod wrote:No idea, because it's not my file. ...

I found on the IBM website that it is bogus warning......i am heading in the direction of applying the patch as suggested by IBM in the following link.

http://www-01.ibm.com/support/docview.w ... wg1JR32253

Will update this post once i get input from IBM support.

Thanks for your help Ray.

No, you found "a" bogus warning issue, don't assume that means any invalid characters message must therefor be bogus. I would wager they meant that specific message, with those characters and integer metadata in play.

We'll be here when you come back.