Topic
  • 1 reply
  • Latest Post - ‏2012-12-06T11:41:57Z by David.Zhu
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic How to execute storedprocedures using data studio

‏2012-10-25T14:14:32Z |
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
    David.Zhu
    67 Posts

    Re: How to execute storedprocedures using data studio

    ‏2012-12-06T11:41:57Z  
    There 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"