Datastage Error

naveen19 · Post by **naveen19** » Thu Feb 21, 2008 1:05 am

Hi Folks,

i having problem in loading the data into the Oracle database

and i am getting new error...if any body having any idea please share it

main_program: Invalid character(s) ([xCD]) found converting string (code point(s):
VALUE[x00][xCD][x09] [x00]) from codepage UTF-8 to Unicode, substituting.

Thanks in Advance

Regards..Naveen.K[/img]

ray.wurlod · Post by **ray.wurlod** » Thu Feb 21, 2008 1:38 am

Study the error message - get everything you can out of it. For example, what are these characters, and why can't they be converted?

naveen19 · Post by **naveen19** » Thu Feb 21, 2008 4:20 am

ray.wurlod wrote:Study the error message - get everything you can out of it. For example, what are these characters, and why can't they be converted? ...

Thanks Ray...
For your guidence
i will do that..once i get the result i will post the result...

Regards..Naveen.K

FDW_CITI · Post by **FDW_CITI** » Thu Oct 02, 2008 9:03 pm

Can anyone explains what this UNICODE signifies in column definitions.

We have defined the NLS Lang as UTF8 and all column datatype is VARCHAR2. We are using Oracle database for loading the data

Do we need to define the extended type as UNICODE?

Regards,
Manju

ray.wurlod · Post by **ray.wurlod** » Thu Oct 02, 2008 9:24 pm

Welcome aboard.

We do not hijack threads with questions irrelevant to the thread.

Please post a new topic with this question.

trokosz · Post by **trokosz** » Thu Oct 02, 2008 9:26 pm

Well setting NLS_LANG is one thing but have you set utf8 in the dsenv? have you set the NLS to utf8 in the DS Admin GUI so all JObs and Stages understand there defaults?

FDW_CITI · Post by **FDW_CITI** » Thu Oct 02, 2008 11:43 pm

Yes, it is set ...

Please respond to my new post with subject "UNICODE for CHAR/ VARCHAR2 columns"

DSXchange

Datastage Error

Datastage Error

UNICODE in Column Definition