Hi!
Does anybode can show me the code for calling Stored procedure on SQL Server.
I need help with this.
VB code for calling SP
Moderators: chulett, rschirm, roy
Hi,
Do you really mean from VB(Visual Basic)???
In DS you can try using the ODBC stored procedure or simly run a user defined sql to run it.
(depending on wether it has a result set or not might determin if you need to use an output or input link.
IHTH,
Do you really mean from VB(Visual Basic)???
In DS you can try using the ODBC stored procedure or simly run a user defined sql to run it.
(depending on wether it has a result set or not might determin if you need to use an output or input link.
IHTH,
Last edited by roy on Mon Jun 27, 2005 3:05 am, edited 1 time in total.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
What stage are you using to load data into SQL server. The stored procedure can be called if the stage has 'Before/After' tabs in the SQL tab. The stage does not have the above options, then you may need to write a routine to call SP. I think Stored procedure in DS supports only Oracle, DB2 & Sybase databases.
Hope you can call the SP using call command. (Call <SP Name>)
HTWH.
Regards
Saravanan
Hope you can call the SP using call command. (Call <SP Name>)
HTWH.
Regards
Saravanan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To invoke a stored procedure from DataStage you must first import the stored procedure definition. If DataStage objects to the import process, then the stored procedure is not amenable to DataStage's method of operation (it must process a record set).
See also this post
See also this post
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.