17.20 - SET TRANSFORM GROUP FOR TYPE Statement - 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

Starting with Advanced SQL Engine 16.20 Update 1, the SET TRANSFORM GROUP FOR TYPE feature is implemented to support changing the active transform for Teradata CDTs that have multiple transforms at a session level. This feature allows the user to use the appropriate transform without having to create separate USER account with different transform settings.

A new DDL statement SET TRANSFORM GROUP FOR TYPE is added. The syntax follows:

<set transform group statement> ::= SET TRANSFORM GROUP FOR TYPE <cdt name> <transform group name>

For more information on this feature, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.