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.

Converting an external SQL procedure to a native stored procedure

You can use change rules to convert an external SQL procedure to a native stored procedure.

Tip

To create a migrate-type work ID, see Creating-a-migrate-type-work-ID.

To convert an external SQL procedure to a native 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 List and press Enter.
  3. On the WORKID Selection List, type E in the Act column adjacent to the work ID that you want to use. Then, press Enter.
  4. On the Edit WORKID panel, type S to select WORKID Change Rules and press Enter.
  5. On the Change Rules panel, type C in the Act column and press Enter.
  6. On the Edit Change Rules panel, specify the information for the change rule:
    1. In the Option field, select Change.
    2. In the Object field, select Stored Procs.
    3. In the Attribute field, type SPType.
    4. In the Current Attribute Value field, type * or leave the field blank.
    5. In the New Attribute Value field, type NATIVE.
  7. Press END until the WORKID Action Menu is displayed.

Related topic

Accomplishing-your-goals

 

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