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 a column to a table

Use the following procedure to add a column to 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 E in the Act column adjacent to the table that you want to modify.
  5. On the Table Detail panel, type S to select Table Column List.

  6. On the Table Columns List, type I in the Act column adjacent to the column name where you want to insert a column and press Enter.If you want to insert a line at the start of the column list, type the I in the Act column on the TOP line or the line that contains three asterisks (***). A blank line is inserted into the list of columns.

    Note

    You can also type L in the Act column to duplicate a column definition. The Like action code creates an identical column listing immediately below the original. You can then edit the name of the column to create a new column.

    Warning

    When you duplicate a column, ensure that you edit the column below the one that contains the L prefix notation. If you edit the original column name, Analysis creates a -RNAM command for the original, renames the original column, and creates a new column with the original name in the CREATE TABLE SQL statement. This action could result in unwanted data, data structure changes, or both.

  7. Type the Column Name, Column Type, Length, and attribute values. You can scroll to the right to enter additional column information or you can type E in the Act column to view a more detailed panel that displays the old and new values. Then, press END until the Mixed List panel is displayed.

    Tip

    Some object names might be too long to be displayed on a panel. To enter a long object name, position the cursor on the object name and press the ZOOM (F4) key.

  8. On the Mixed List panel, press END.

    Note

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

  9. If necessary, you can make additional changes on the Object Specification panel. Then, press END until you return to the WORKID Action Menu.Now that a column has been added to 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*