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, refer to SQL Data Definition Language - Syntax and Examples (B035-1144).