16.20 - Set Transform Group for Type - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K
You can use the SET TRANSFORM GROUP FOR TYPE statement to set the active transform for Complex Data Types (CDTs) that have multiple transform groups, including:
  • JSON
  • XML
  • ST_GEOMETRY
  • DATASET

Benefits

Previously, using multiple transform groups required you to create a USER with transform settings. This feature enables you to apply session level transform settings for Teradata CDTs without having to create a USER with transform settings. For example, during load operations, you can switch the active transform without having to create a separate user.

You can use new and updated macros to display the current UDT transforms.

You can use SET TRANSFORM GROUP FOR TYPE to add transforms in addition to existing transform settings for the user.

SQL Changes

You use the following new statement to set transform groups for CDTs:
  • SET TRANSFORM GROUP FOR TYPE

Considerations

If default transform groups are already set for the user, the SET TRANSFORM GROUP FOR TYPE statement overrides the default settings for the current session.

JSON and XML in MultipartRecord Mode have a special transfer protocol that does not use transforms. External JSON and external XML data transferred from clients to Teradata Database are also processed without transforms. In this mode, the SET TRANSFORM GROUP FOR TYPE statement does not apply. However, JSON and XML can use transforms in Field, Record, and Indicator modes. You can use the SET TRANSFORM GROUP FOR TYPE statement to set the session transform for JSON and XML data in Field, Record, and Indicator modes.

Additional Information

For information about CDTs, including macros you can use to display the current transform settings, see:
  • Teradata Vantage™ JSON Data Type, B035-1150
  • Teradata Vantage™ XML Data Type, B035-1140
  • Teradata Vantage™ DATASET Data Type, B035-1198
  • Teradata Vantage™ Geospatial Data Types , B035-1181