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.

Adding WITH RESTRICT ON DROP to tables by importing DML

Use this procedure to import DML to add a WITH RESTRICT ON DROP clause to the table specification for all tables in a database.

To add WITH RESTRICT ON DROP to tables

 

Note

You can also perform this task by using the CM/PILOT DML_STRUCTURE_CHG script. For more information, see Changing-data-structures-by-using-DML.

  1. In an ISPF editor, type the DML statement to match the one shown in the following figure and provide the information that is unique to your site.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

    UPDATE TABLES
    SET
         CLUSTERTYPE = 'Y'
    WHERE
         DBNAME = 'DEMOCRJ'
    ;
  2. Import the DML file.Now that the DML file has been imported, 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*