Run a stored procedure in the database using the Apache Derby connection.
- From Data Source Explorer, under Databases, expand the Derby Embedded connection profile tree.
- Under the appropriate database, expand the SYSIBM schema, then expand Stored Procedures.
- Right-click the stored procedure that you want to run and select Run.
The stored procedure opens in an editor window.
- (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.