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.

ALTER MASK statement

The ALTER MASK statement defines the changes to a column mask.

 
alterMask_bqu1880.png

ALTER MASK schema.maskName

This option specifies the name of the column mask to change.

SCHEMA newSchema

This option specifies the name of the new schema to which the column mask belongs.

NAME newName

This option specifies the new name of the column mask.

ENABLE

This option makes the column mask operative for column access control on the table.

ENABLE value parameters

Value

Description

YES

Makes the column mask operative for column access control on the table.

NO

Makes the column mask inoperative for column access control on the table.

COMMENT 'newCommentString'

This option updates the column mask comment.

COLUMN newColName

This option changes the column to which the mask applies. newColName must be an unqualified name that identifies a column of the specified table.

TBCORRELATION newTableCorrelation

This option changes the correlation name for the table associated with the column mask.

MASKTEXT(newMaskText)

This option updates the CASE expression that determines the value returned for the column.

PATH (schemaList)

This option specifies the path for the mask.


Related topics

CDL-statements

CREATE MASK statement

ALTER-TABLE-statement





 

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