DSXchange

Hi,

I would like to know if there is any function in DataStage to convert from

1. double to decimal
2. double to char

Regards,

badri wrote:,
1. double to decimal
2. double to char

1. You will have to write a transform to do this. Use the FMT function to do this. Look it up in the help.

2. You don't need to do this in Datastage. Everything in Datastage is a 'string' so you will not need a function to do this. What did you want to accomplish with the 'double to char' conversion?