Authorized data truncation (ADT) helps in resolving the SQL width problem that arises when database field values exceed the defined field width. ADT can prevent query failures caused by the reading of large field values. By default, SQL returns an error, and the query fails if the width of the field data being operated on in the query exceeds the defined width of the field. SQL will truncate the large value to the specified size if ADT is enabled.

For a DDM-configured field, ADT is processed on the masked data for unauthorized users and on the unmasked data for authorized users.
SELECT Address FROM pub.Customer;

If Address is a DDM-configured field, the SQL engine processes ADT using the masked value of Address for unauthorized users and the unmasked value for authorized users.