NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-12-06T11:41:57Z by David.Zhu
Pinned topic How to execute storedprocedures using data studio
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
CAn anyone say how to execute the storedproc using data studio
Updated on 2012-12-06T11:41:57Z at 2012-12-06T11:41:57Z by David.Zhu
David.Zhu 270000SSPX66 PostsACCEPTED ANSWER
Re: How to execute storedprocedures using data studio2012-12-06T11:41:57Z in response to SystemAdminThere are two way to call store procedure using data studio.
1.Add a DB2 server connection in the "Data Source Explore".
2.Open the connection
3.Navigate to the store procedure. (database->schema->store procedure)
4.choose the procedure you want to execute and in the right key menu choose "run"
5.If this procedure have input parameters, it will popup a parameter dialog input you parameter and click ok.
6.you can check the result at the "Result View"