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.
- SET TRANSFORM GROUP FOR TYPE
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.
- 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