Type conversion functions

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
badri
Participant
Posts: 19
Joined: Mon Jul 12, 2004 2:58 am

Type conversion functions

Post by badri »

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,
:)
davidnemirovsky
Participant
Posts: 85
Joined: Fri Jun 04, 2004 2:30 am
Location: Melbourne, Australia
Contact:

Re: Type conversion functions

Post by davidnemirovsky »

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?
Cheers,
Dave Nemirovsky
Post Reply