Data encryption can also be turned ON or OFF at the statement level. The data encryption behavior set at the statement level is applicable only for the particular statement handle, and transactions done for that statement handle only.
At the statement level, data encryption can be turned ON/OFF by setting ODBC Driver for Teradata-defined attribute SQL_ATTR_DATA_ENCRYPTION(13008) to:
- SQL_DATA_ENCRYPTION_ON(1) or
This statement-level attribute overrides the connection-level data encryption option. For example, encryption can be turned ON or OFF with this attribute for a particular statement handle irrespective of the connection level setting. All other statement handles under the same connection handle use data encryption as per the connection level setting as the default.