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.

SET clause

The SET clause of a DML statement specifies changes to the attributes of the data structures or to the data structures.

SET attribute = value

Sets an attribute of an object to a value.

attribute

Specifies the attribute that you want to set. For a list of the attributes that you can set, see Attributes-used-in-SET-and-WHERE-clauses. For more information about attributes, see the descriptions in the IBM documentation.

You can find the associated catalog table name in Keywords. The term attribute as used in CM/PILOT DML is synonymous with the column names of Db2 catalog tables.

For example, if you want details about the LOCATION attribute of aliases, you can follow these steps:

  1. Look at Keywords of this guide. Use the SYSIBM.SYSTABLES catalog table for updating aliases.
  2. Look in the IBM documentation that references the SYSIBM.SYSTABLES catalog table. The documentation should include a description of the LOCATION column name, which is synonymous with the LOCATION attribute that is used in CM/PILOT DML.

value

Specifies the new value for the attribute that you are setting. The value can be a constant or an expression. If you need more space than an input field provides on a panel, edit the DML statement. For example, you can set a NAME attribute with either of the following values: 'ABCD' or 'PROD' CONCAT SUBSTR(NAME,5). You can set a numeric attribute such as PQTY, with any of the following values: 123, PQTY * 2, or SQTY * 4.

Related topic

DML-statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*