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.