Skip to Content

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.

Success

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*

ALTER and BMC AMI Change Manager for Db2 13.1