Unable To Get Out From This

knip1 · 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 · 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.

knip1 · 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 · 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 · 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).

vamsi.4a6 · 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 · 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 · 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 · Post by **ntr** » Mon Jul 09, 2012 4:04 am

Thank You So Much ArndW