In StoredProcedure (STPPX) stage Genral tab,under Database Vendor drop down list I am seeing Oracle only.
How can I invoke a SQL Server Stored procedure through the StoredProcedure Stage.
Invoking SQL Server Stored procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Invoking SQL Server Stored procedure
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is only one way using the Stored Procedure stage, and that is to be patient and wait until "they" incorporate support for SQL Server stored procedures into the stage type.
Meanwhile, you can get at recordset-handling stored procedures through the ODBC Enterprise stage or the Dynamic RDBMS (DRS) stage.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Meanwhile, you can get at recordset-handling stored procedures through the ODBC Enterprise stage or the Dynamic RDBMS (DRS) stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA