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
naveen19
Participant
Posts: 52 Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
naveen19
Participant
Posts: 52 Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
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
Participant
Posts: 13 Joined: Sun Aug 31, 2008 10:18 pm
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
trokosz
Premium Member
Posts: 188 Joined: Thu Sep 16, 2004 6:38 pm
Contact:
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
Participant
Posts: 13 Joined: Sun Aug 31, 2008 10:18 pm
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"