DSXchange

Posted: **Mon Mar 29, 2010 10:55 am**

How to invoke a mainframe stored procedure.
Actually there are no input parameters. This SP is run on a staging table.
there is one return code and 20 output parameters.

Posted: **Mon Mar 29, 2010 1:34 pm**

What database?

For example, if it's DB2, you can call the stored procedure through DB2 Connect.

Posted: **Tue Mar 30, 2010 1:17 am**

ray.wurlod wrote:What database?

For example, if it's DB2, you can call the stored procedure through DB2 Connect. ...

It is a DB2 database only ray. But I need to capture the output parameters and load to a Oracle DB

DSXchange

Invoking Mainframe Stored Procedure

Invoking Mainframe Stored Procedure