Converting Numeric to Varchar

jweir · Post by **jweir** » Thu Nov 04, 2010 9:26 am

Hello,

I need to convert a numeric field into a varchar when I am loading into my DB2 target. I have tried the DecimalToString function, but returned blanks. I also got the same result when I tried the Char() function.

I am extracting this field from SAP, which comes as a numeric. But my DB2 target needs to be Varchar.

Any suggestions?

Thanks in advance.

vinothkumar · Post by **vinothkumar** » Thu Nov 04, 2010 9:31 am

Dont use any function. I believe it will convert automatically.

jweir · Post by **jweir** » Thu Nov 04, 2010 9:35 am

I forgot to mention that in that field, I have padded that numeric value with a zero at the end of it (i.e. 2010). So when I straight pass it, that zero gets dropped.

vinothkumar · Post by **vinothkumar** » Thu Nov 04, 2010 9:38 am

What is the target datatype and its size

jweir · Post by **jweir** » Thu Nov 04, 2010 9:41 am

datatype: varchar
size: 4

vinothkumar · Post by **vinothkumar** » Thu Nov 04, 2010 9:42 am

How are you padding zeros at the end

jweir · Post by **jweir** » Thu Nov 04, 2010 9:45 am

Ok, apparently there was never a padded zero. The field comes in as 2010, numeric. But when I straight pass it to the varchar target, the last zero is dropped, resulting in 201.

anbu · Post by **anbu** » Thu Nov 04, 2010 9:58 am

First character in integer is for sign which is a space for positive number. Trim the numeric field and assign to target field

jweir · Post by **jweir** » Thu Nov 04, 2010 11:52 am

Thanks anbu. It worked.