DSXchange

Hi,

I am extracting data from one DB source and inserting it into another. On the insert I need to call a function to encrypt one of the fields being inserted. How do I do that in Data Stage.

Thanks

Use your own 'user defined' SQL to do that insert, modeled after what the stage is currently using, but with the function call you need added.

I tried that, but the insert didn't execute the function

Done properly, there's no way that it can't "execute the function". How about some details, please. What database, target stage, actual SQL used, options in the stage, messages in the log - anything that can help us help you.