Creating DB2 or Derby stored procedures from the Data Project Explorer

You can use the New Stored Procedure wizard to create DB2® stored procedures in SQL or Java™, or Derby stored procedures in Java.

Prerequisite: You must create a data development project.

Using the New Stored Procedure wizard, you name the stored procedure, specify the stored procedure language, define the structure and SQL statement, and specify the parameters and additional options. You can also customize the generated source code by specifying files that contain code fragments. You can specify the following types of code fragments:

To create a stored procedure from a data development project:

  1. Switch to the Data perspective.
  2. In the Data Project Explorer, right-click the Stored Procedures folder in a data development project, and click New. The New Stored Procedure wizard opens.
  3. Complete the steps of the wizard. If you opened the wizard by using the toolbar button, you must provide project and connection information in the wizard.
The wizard creates the stored procedure and adds it to the Stored Procedures folder, and the stored procedure opens in the routine editor.

Comentarios