Changing the data type and length of a column

Use the following procedure to change the data type of a column and the length of a column. You can also change any of the column attributes for existing data, provided that the data can be converted to the new definition.

  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, modify the value of the Column Type column for the column that you want to change.

    Tip

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

  6. Modify the value of the Length column for the column that you want to change.
  7. Press END.

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

    Important

    On the Mixed List pane, an asterisk (*) and a change-level indicator are displayed adjacent to the object that you changed.

    Now that the data type of a column has been changed, 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*