Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Creating a new version of a native SQL stored procedure

Use the following procedure to create a new version of a native SQL stored procedure.

  1. On the BMC AMI Change Manager for Db2 Main Menu, select WORKID, and press Enter.
  2. On the WORKID Action Menu, type the name of the WORKID or type a wildcard pattern to display a list of work IDs. Then, select Specify Db2 definitions and press Enter.
  3. On the Object Specification panel, specify the name of a stored procedure (or use wildcard characters). Then, press Enter.

  4. On the Mixed List panel, type L in the Act column adjacent to the native SQL stored procedure (SPN) or the active native SQL stored procedure (SPNA).

    Note

    To create a new version of a native SQL stored procedure, you must copy an existing native SQL stored procedure. The procedure can exist in the Db2 structures or in a change request in a work ID.

  5. Specify the options for the new version of the native SQL stored procedure.

    Note

    All versions of a native SQL stored procedure must have the same procedure signature. The procedure signature includes the Procedure Owner, Procedure Schema, Procedure Name, Parameter CCSID, number of parameters, and attributes for the parameters.

    1. At Procedure Version, type a new value for the version. The version must begin with an alphabetic character.

    2. At Add Version, type Y.

      Note

      If you type N at Add Version, the product attempts to create a new native SQL stored procedure.

    3. Specify any other options for the procedure.
  6. Specify additional options for the native SQL stored procedure.
    1. Type S to select Proc Options.
    2. At Active, type Y or N to indicate whether the version of the procedure is the active version.
    3. Specify any other additional options for the procedure.
    4. Press END.
  7. To specify the parameters for the native SQL stored procedure, type S to select Parameters.
  8. On the Procedure Parameter List panel, specify the parameters, and then press END to return to the Create Procedure panel.
  9. On the Create Procedure panel, to specify the comment for the native SQL stored procedure, type S to select Comment.
  10. On the Procedure Comment panel, modify the comment, and then press END to return to the Create Procedure panel.
  11. On the Create Procedure panel, to modify the text for the native SQL stored procedure, type S to select Text.The product invokes the ISPF editor.
  12. Using the ISPF editor, modify the text. If the body exceeds the width of the screen, you can scroll the panel to the right to provide additional text. Then, press END to return to the Create Procedure panel.
  13. On the Create Procedure panel, to view the previous text for the native SQL stored procedure, type S to select View Old Text.The product invokes the ISPF browse utility.
  14. In the ISPF browse utility review the text for the native SQL stored procedure that existed before you made changes. Press END to return to the Create Procedure panel.
  15. On the Create Procedure panel, to specify the path for the native SQL stored procedure, type S to select Path.
  16. On the Procedure Package Path panel, modify the path, and then press END to return to the Create Procedure panel.
  17. Press END.Now that the new version has been created, you can analyze a work ID and execute a worklist.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*