Numeric to String conversion

[Rajesekhar]

How can we convert Numeric to VarChar in DataStage?

Please help!!

Thanks, Raj

[anbu]

You can assign numeric fields directly to varchar target field. Its implicit conversion

[Rajesekhar]

I am having a dataset one of the column names is ID whose values are like 000123, 000124 etc.. This is of DataType numeric.

I have a table to which I need to do a lookup using these values.. table has values like 123, 124 etc.. This is of data type VarChar.

So from the above dataset input I need to takeout leading zeros to do a proper lookup and get going.

How can I do that?

I thought of converting numeric to string and strip the leading zeros using Trim function.

Could you suggest me a better way if we have any?

Thanks, Raj.

[anbu]

Use StringToDecimal() to convert your Varchar field to Integer and join on integer fields. Leading zeros in integer wont affect your join.