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

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
    66 Posts
    ACCEPTED ANSWER

    Re: How to execute storedprocedures using data studio

    ‏2012-12-06T11:41:57Z  in response to SystemAdmin
    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"