After you create and deploy a routine such as a stored
procedure or user-defined function, you can run the routine on the
database server.
About this task
Restriction: Some products do not support Java routines.
Note: You should
not run routines by using the Run As option
from the pop-up menu in the routine editor.
Procedure
To run a SQL or Java routine:
- In either the Data Source Explorer or
the Data Project Explorer, right-click the routine
that you want to run, and click Run. Run
Routines opens.
- Specify parameters and run options.
The routine runs on the database server.
- View the results that correspond to the run action in the SQL
Results view. You can view messages, parameters,
and result sets.
Tip: If you gathered performance information
for an SQL routine, the information appears in the SQL Results view.
For SQL statements that perform poorly, you can right-click the statement
and click Start Tuning to open the InfoSphere® Optim™ Query Tuner and tune the statement.
Results
The parameters and run options are retained. You can change
the values when you run the routine again.
What to do next
You can specify test configurations for your routines.