Invoking Mainframe Stored Procedure

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dineshrk
Participant
Posts: 46
Joined: Thu Jun 26, 2008 9:14 pm

Invoking Mainframe Stored Procedure

Post by dineshrk »

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.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

What database?

For example, if it's DB2, you can call the stored procedure through DB2 Connect.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
dineshrk
Participant
Posts: 46
Joined: Thu Jun 26, 2008 9:14 pm

Post by dineshrk »

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
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”