Changing column categories when altering a table

Use the Change Column Categories window of the Alter Table notebook to change the default values for the columns in the predefined column lists.

Fields and controls



To change the default values of predefined columns:

  1. Open the Change Column Categories window of the Alter Table notebook.
  2. To change a list name:
    1. In the Category name box, select a column category whose name you want to change.
    2. In the Category name field, type a new name for the column category.
    3. Click on the Change push button next to the Category name box.
  3. Change the default values of a column:
    1. In the Columns box, select a column whose default values you want to change.
    2. Click on Change. The Change Column window opens. Make any of the following changes to the column definition:
      • Change the name of the column by typing a new name in the Column name field.
      • Use the Data type box to specify a different data type.
      • If the data type of the column is CHARACTER, VARCHAR, BLOB, CLOB, DBCLOB, GRAPHIC, or VARGRAPHIC, change the length of the column by typing a new length in the Length field.
      • If the data type of the column is BLOB, CLOB, or DBCLOB, use the LOB unit box to specify a new multiplier for the length of columns.
      • If the data type of the column is DECIMAL:
        1. In the Precision field, type the new precision (total number of digits) for the column.
        2. In the Scale field, type the new scale (number of digits to the right of the decimal) for the column.
      • If the data type of the column is BLOB, CLOB, DBCLOB, or a distinct type with any of these as source types, specify the LOB options by selecting or clearing the appropriate LOB option check boxes.
      • If the data type of the column is CHARACTER, VARCHAR, or LONG VARCHAR, select or clear the Bit data check box to specify whether the contents of the column be treated as bit (binary) data.
      • Select or clear the Nullable check box to indicate whether you want to allow the column to contain null values.
      • In the Default field, type a new default value for the column.
      • Optional: In the Comment field, type a new comment or edit the existing comment.
      • Optional: If you selected a generated column, and the values for that column are generated by a formula, you can use the field associated with the Formula radio button to change the formula that DB2 uses.
    3. Click on OK to make the changes you specified for the column and close the Change Column window.
  4. Click on OK to save the changes that you specified for the predefined column and close the Change Column Categories window.


Related information