The UPDATE statement can update a DDM-configured field only when you have unmasking privileges over the field; otherwise, an error occurs.

Example

The following example illustrates the UPDATE statement for a DDM-configured field.
UPDATE PUB.Customer SET Phone=12345678 WHERE CustNum = 1188;
In this example, Phone and CustNum are DDM-configured fields. You can update PUB.Customer only when you are authorized to unmask the Phone field; otherwise, the update operation fails. Irrespective of your DDM privileges, the WHERE condition uses unmasked vaule of CustNum.