DSXchange

Hi,

My DS job is creating the Insert statements dynamically. Due to bad design of DB everything in my job including Table name is dynamic. I need to execute these statements on Oracle DB in the parallel job. How can i do that, i tired using Db connector for Pl/SQL but i had to provide it the input file as parameter but not able to use the input stream as input to the DB conncetor.

Any Help is really appreciated.

Thanks

You could try generating the entire SQL in a previous (server?) job and providing it to your loading job as a parameter value.