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.

CREATE MASK statement

The CREATE MASK statement defines a column mask for a table.

createMask_bqu1880.png

CREATE MASK schema.maskName

This option specifies the name of the column mask for the table.

TABLE tableOwner.tableName

This option identifies the table on which the column mask is created.

ENABLE YES

This option specifies that the mask is operative for column access control on the table.

COMMENT 'commentString'

This option specifies the column mask comment.

COLUMN columnName

This option identifies a column of the table to which the mask applies.

TBCORRELATION correlationName

This option specifies the correlation name for the table for use in the maskText.

MASKTEXT(maskText)

This option specifies a case expression that is used to determine the value returned for the column.

CURRENT SCHEMA schema

This option specifies the current schema of the permission. This option corresponds to SET CURRENT SCHEMA.

PATH (schemaList)

This option specifies the path for the mask.


Related topics

CDL-statements

ALTER MASK statement

ALTER-TABLE-statement





 

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