17.20 - Statement Level - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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.