Stored Procedure Stage (STP)

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
beck.ryan@principal.com
Participant
Posts: 3
Joined: Wed Oct 05, 2005 7:13 am

Stored Procedure Stage (STP)

Post by beck.ryan@principal.com »

We have DataStage Server Edition version 7.5.

I want to call a DB2 stored procedure through the Stored Procedure Stage. When I import the STP stage into the job, I only have Orable available as a database vendor. I read the technical bulletin for this stage and it states that Oracle is the only supported platform for this stage at the time the technical bulletin was written. Does anyone know if this has changed since the bulletin was written? I also read the documentation on calling a stored procedure from an ODBC stage but the documentation stated return values/output values are ignored. The particular stored procedure I am trying to invoke has output information that I need. Any help is appreciated.
Top
Post Reply

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