Dropping a column from a table

Use the following procedure to drop a column from a table:

  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 (or use wildcard characters) of any data structures to be included in a list. Then, press Enter.
  4. On the Mixed List panel, type CO in the Act column adjacent to the table that you want to modify.
  5. On the Table Columns List, type D in the Act column adjacent to the name of the column that you want to remove and press END.

  6. On the Mixed List panel, press END until the WORKID Action Menu is displayed.

    Important

    The Mixed List panel is displayed. An asterisk (*) and a change-level indicator are displayed adjacent to the object that you changed.

    Now that a column has been removed from a table. 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*