DSXchange

Hi! Evryone,

I have a table/file containing a list of policy_nos and I have a stored procedure, which takes this policy_no as a parameter to generate some output.
so, my question is, how can I implement it in DS?
I Need to call the procedure for ecah policy_no in the list.

Any suggestions?

Thanks
Kalpana.

Import the Stored Procedure definition into DataStage. This will give you the columns corresponding to its arguments.

Call the stored procedure (from an ODBC stage, etc., or from a Stored Procedure stage).

Hi! Ray,
I think,
the problem is not executing the stored procedure. but, how should I pass more than one policy number into stored procedure...
I mean, calling stored procedure for every policy....!!!

how is that possible?

BAsically my question is, How can we call a stored procedure repititively with different arguments?

Using a stored procedure stage, how can we pass a dynamic parameter?

How can we implement this in DS?

Select the table that contain the policy_no thorugh a oracle stage and link it to the ODBC stage which calls the stroed procedure. The output of the OCI will the input for the ODBC.

For that, you could use the Stored Procedure stage rather than ODBC. It can be used like a transformer, so to speak, on a row by row basis.

What version of DataStage? What database?