Statement Level - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.