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
dineshrk
Participant
Posts: 46 Joined: Thu Jun 26, 2008 9:14 pm
Post
by dineshrk » Mon May 24, 2010 11:30 pm
Hi,
I am getting the below warning while extracting data from sql db, for this i had enabled RCP. Please let me know whether it is related to data issue or i have to change any setting in my job.
Please find the below warning for reference.
Warning:
main_program: Invalid character(s) ([xC0]) found converting string (code point(s): NAMECONFIDENCESCORE[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xC0][xEB][xE4][x09][x09][x00]) from codepage UTF-8 to Unicode, substituting.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue May 25, 2010 12:01 am
Is this a binary (numeric) field that you're trying to read as a character string?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dineshrk
Participant
Posts: 46 Joined: Thu Jun 26, 2008 9:14 pm
Post
by dineshrk » Tue May 25, 2010 12:37 am
Actually it is of string datatye.
NAMECONFIDENCESCORE: nullable string[3,padchar=' '];
ray.wurlod wrote: Is this a binary (numeric) field that you're trying to read as a character string? ...
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue May 25, 2010 2:32 am
What about in the source?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dineshrk
Participant
Posts: 46 Joined: Thu Jun 26, 2008 9:14 pm
Post
by dineshrk » Tue May 25, 2010 2:53 am
Sorce is also is of string type
ray.wurlod wrote: What about in the source? ...
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue May 25, 2010 5:05 am
Can you use another utility to display what's actually in the source in this particular field? If so, please post the result of that exercise.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.