how can i call a function on an insert statement

ep_datastage · Post by **ep_datastage** » Wed May 10, 2017 8:41 am

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

chulett · Post by **chulett** » Wed May 10, 2017 9:10 am

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.

ep_datastage · Post by **ep_datastage** » Wed May 10, 2017 9:12 am

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

chulett · Post by **chulett** » Wed May 10, 2017 9:15 am

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.