Page 1 of 1
Unable To Get Out From This
Posted: Sun Jul 08, 2012 12:22 am
by knip1
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.
Posted: Sun Jul 08, 2012 1:43 am
by ray.wurlod
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.
Posted: Sun Jul 08, 2012 3:48 am
by knip1
Thanks ray, Issue is now resolved, i changed the datatype from char to Nchar
Posted: Sun Jul 08, 2012 6:36 am
by vamsi.4a6
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?
Posted: Sun Jul 08, 2012 6:21 pm
by ray.wurlod
Specify Unicode, write to a text file, view using a hex display utility (for example UltraEdit).
Posted: Sun Jul 08, 2012 9:59 pm
by vamsi.4a6
@ray.wurlod
Thanks for the Reply.Could you please help me where to specify this unicode property while writing to a text file?
Posted: Mon Jul 09, 2012 2:54 am
by ntr
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
Posted: Mon Jul 09, 2012 3:43 am
by ArndW
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
Posted: Mon Jul 09, 2012 4:04 am
by ntr
Thank You So Much ArndW