DSXchange

Hi,

I have requirement here. I need to run a SQL query on a table to find whether the desired values are present. If yes, then I need to execute a stored procedure.

Can I achieve it in the following way?

I have a job containing three stages, a source Oracle/ODBC stage, a transformer and a target Oracle stage.

In the first stage, I need to execute a query on a table. In the transformer stage, I need to take the output of source stage to see whether I have the desired values. If these values are present, I need to go to the target stage. My target stage needs to execute a stored procedure (The stored procedure definition is impoted before-hand).

Is this scenario possible? Else, please provide me with other options.

Cheers,
Mohan

If you can call the stored procedure in SQL, you can do it in DataStage.

Since you're using Oracle, there's a Stored Procedure Stage on DataStage EE 7.5 that can do what you need.

Also, why not just use the stored procedure stage to check whether it should run or not?