Running a Stored Procedure

Run a stored procedure in the database using the Apache Derby connection.

1. From Data Source Explorer, under Databases, expand the Derby Embedded connection profile tree.
2. Under the appropriate database, expand the SYSIBM schema, then expand Stored Procedures.
3. Right-click the stored procedure that you want to run and select Run.

   The stored procedure opens in an editor window.

4. (Optional) In the Configure Parameters dialog, change the default values as necessary and click OK.

   The stored procedure executes, and the output displays in the SQL Results view.