Statement Level

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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
  • SQL_DATA_ENCRYPTION_OFF(0)

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.