Starting with Teradata Database 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.