IBM Database Add-Ins for Visual Studio  

Creating SQL and SPL Procedures from Existing Procedures

If you want to create an SQL or SPL procedure that is similar to an existing procedure in your IBM database, you can base the new procedure on the existing procedure definition.

To create an SQL or SPL procedure from an existing procedure:

  1. In the Server Explorer under your IBM data connection, expand the Procedures folder.
  2. Right-click the procedure that you want to use as the basis for the new procedure, and then select Clone Definition on the shortcut menu.

    The IBM Procedure Designer opens, with the information for the selected procedure displayed in the fields of the designer. The values in the Procedure name and Specific name fields contain an incremental numeric suffix.

  3. Change, add, or delete the information in the views of the designer to define the new procedure.

    For detailed information about the fields in the designer views, see IBM Procedure Designer.

  4. Save the procedure definition.

    The SQL or SPL procedure is created and added to your database.

  5. Close the designer.

See Also

Developing IBM Database SQL and SPL Procedures | DB2 SQL Procedures | Informix SPL Procedures | Managing Procedures, Functions, and Objects


.NET Development Forum   DB2 FAQs   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.