Executing target stage based on the source stage input

sathyanveshi · Post by **sathyanveshi** » Thu Dec 23, 2004 4:37 am

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

T42 · Post by **T42** » Mon Dec 27, 2004 7:18 pm

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?