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
knip1
Participant
Posts: 5 Joined: Tue Nov 30, 2010 11:57 am
Post
by knip1 » Sun Jul 08, 2012 12:22 am
HI Experts,
Please help me to solve the below error
main_program: When preparing operator: When setting up transfer for "COL_A":Implicit conversion from source type "ustring[5]" to destination type "string[5]": Converting ustring to string using codepage ISO-8859-1.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sun Jul 08, 2012 1:43 am
Maybe mark the target string extended property as Unicode.
Otherwise find out which character is not being handled as ASCII in your data, and handle it appropriately.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
knip1
Participant
Posts: 5 Joined: Tue Nov 30, 2010 11:57 am
Post
by knip1 » Sun Jul 08, 2012 3:48 am
Thanks ray, Issue is now resolved, i changed the datatype from char to Nchar
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
Post
by vamsi.4a6 » Sun Jul 08, 2012 6:36 am
ray.wurlod wrote: Otherwise find out which character is not being handled as ASCII in your data, and handle it appropriately. ...
I am beginner for Datastage. Could anybody please help me how to find out which character is not being handled as ASCII in your data?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sun Jul 08, 2012 6:21 pm
Specify Unicode, write to a text file, view using a hex display utility (for example UltraEdit).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vamsi.4a6
Participant
Posts: 334 Joined: Sun Jan 22, 2012 7:06 am
Contact:
Post
by vamsi.4a6 » Sun Jul 08, 2012 9:59 pm
@ray.wurlod
Thanks for the Reply.Could you please help me where to specify this unicode property while writing to a text file?
ntr
Participant
Posts: 110 Joined: Fri Dec 18, 2009 10:30 am
Location: pune
Post
by ntr » Mon Jul 09, 2012 2:54 am
ray.wurlod wrote: Specify Unicode, write to a text file, view using a hex display utility (for example UltraEdit). ...
What is hex display utility
Thanks
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Jul 09, 2012 3:43 am
vamsi.4a6 - The unicode property is part of the text columns, each one can have its own setting.
ntr - A hex display utility is some program that shows the hex values for data. A simple one one is "od -x" in UNIX and many text editors have a hex display mode
ntr
Participant
Posts: 110 Joined: Fri Dec 18, 2009 10:30 am
Location: pune
Post
by ntr » Mon Jul 09, 2012 4:04 am
Thank You So Much ArndW