Stored Procedure Stage (STP)
Posted: Wed Mar 22, 2006 11:47 am
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.
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.