Special Query Syntax
The Simba Teradata ODBC Connector includes support for SET TRANSFORM GROUP FOR TYPE statements when connected to a Teradata Database instance that also supports this syntax. This DDL statement enables you to specify the transform group to use on Teradata complex data types (CDTs) that support multiple transform groups on the session level.
Typically, to specify a transform that you want to use for one of these CDTs, you would have to create a user account with the transform settings defined. The SET TRANSFORM GROUP FOR TYPE statement enables you to use the appropriate transform without having to create an additional user account. You can execute this statement multiple times to change transform groups during the same session, if needed.
For detailed information about how to write and execute the SET TRANSFORM GROUP FOR TYPE statement, see "SET TRANSFORM GROUP FOR TYPE Statement" in the ODBC Driver for Teradata User Guide.
Important:
The SET TRANSFORM GROUP FOR TYPE statement must be executed before the preparation of the main query or after the execution of the main query. If you execute this statement during any other stage of the main query, the connector returns the following error message:
Error occurred as a SET TRANSFORM GROUP FOR TYPE statement was executed between PREPARE and EXECUTE.