Creating stored procedures

You can use Unified Modeling Language (UML) class diagrams to create Structured Query Language (SQL) stored procedures and add them to databases.

In your project, you must have a database diagram that already has database and schema objects open in the diagram editor before you can create stored procedures.
To create a stored procedure:
  1. In the Palette, click Stored Procedure.
  2. Click inside the diagram editor where you want to place the new stored procedure.
  3. Follow the instructions in the New SQL Stored Procedure wizard.
  4. Click Finish.
Related concepts
Class diagrams
Related tasks
Creating databases
Creating database schemas
Creating database views
Creating data tables
Creating user-defined functions
Related reference
Mappings between data objects and UML elements
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.