WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Creating stored procedures

Use the Create Stored Procedure window to define a stored procedure to perform work that cannot be done with SQL DELETE, INSERT, SELECT, and UPDATE operations.

Procedure

To define a stored procedure:

  1. Open the Create Stored Procedure window by right-clicking either the database in your data model or a schema and selecting Add Classic Object > Stored Procedure.
  2. On the Stored Procedure Definition page, specify where in your project you want to define the stored procedure and specify values to be used in the DDL that is generated for the stored procedure.
  3. On the Parameter Definition page, specify at least one parameter. You can use parameters for input, output, or both.
  4. Click Finish to add the stored procedure to your project.

After the stored procedure is listed in your data model, you can select it and edit any of its properties in the Properties view. You can also set privileges on it.

When the stored procedure is ready, you can generate and run the DDL for creating the stored procedure in a metadata catalog.

If you need to modify the stored procedure after it exists in a metadata catalog, you must generate and run the DDL to drop the stored procedure from the metadata catalog. Then, you can re-create the stored procedure with the modified settings and generate and run the DDL.

Related concepts
Mapping data for Classic federation
Viewing and modifying objects
Populating metadata catalogs
Related tasks
Creating tables and views for DB2 for z/OS databases
Creating indexes
Modifying the PCB selection for IMS tables or indexes
Creating Adabas tables and views for Classic federation
Creating CA-Datacom tables and views for Classic federation
Creating CA-IDMS tables and views for Classic federation
Creating CICS VSAM tables and views for Classic federation
Creating IMS tables and views for Classic federation
Creating VSAM tables and views for Classic federation
Creating sequential tables and views for Classic federation
Related reference
Stored procedure properties


Feedback

Update icon Last updated: 2007-07-11