Running a Stored Procedure

Call a stored procedure in the database using your Apache Derby connection.

  1. From the Navigator, expand the SYSIBM schema, then expand Stored Procedures.
  2. Right-click the stored procedure that you want to run and select Run.

    The routine editor and a dialog for input value entry open.

  3. Change the default values as necessary and click OK.

    The stored procedure is executed and the output displays in the SQL Results view.

Related concepts
Apache Derby
Database Development Perspective
SQL Results View