Creating stored procedures from the Data Project Explorer

You can use the New Stored Procedure wizard to create SQL or Java™ stored procedures.
Prerequisites:

Routine development is not supported for every available data source. See Stored procedure and user-defined function support by server type for details.

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. For Java stored procedures that target DB2 for z/OS® Version 9, you can specify JAR file Java path information. 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.

Feedback