XML Type Transform | Teradata Vantage - XML Type Transform - Analytics Database - Teradata Vantage

XML Data Type
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantage™

The XML type in Field, Record, and Indicator modes uses transforms. The XML type has the following predefined transform groups to convert objects to CLOB, BLOB, VARCHAR, and VARBYTE.

Transform Group Complex Data Type Primary Type Default Format
TD_XML_CLOB XML CLOB Yes Text format in CHARACTER SET UNICODE
TD_XML_BLOB XML BLOB No Text format in UTF-8
TD_XML_VARCHAR XML VARCHAR(32000) No Text format in CHARACTER SET UNICODE
TD_XML_VARBYTE XML VARBYTE(64000) No Text format in UTF-8

You can use the TRANSFORM option in the CREATE PROFILE/MODIFY PROFILE or CREATE USER/MODIFY USER statements to specify for a user the particular transform group that will be used for a given data type.

Use the SET TRANSFORM GROUP FOR TYPE statement to change the active transform group in the current session. You can use this statement multiple times for a data type to switch from one transform group to another within the session. If the logon user already has transform settings, the statement modifies the transform settings for the current session.

You cannot use CREATE TRANSFORM or REPLACE TRANSFORM to create new transforms for complex data types (CDTs). You can only create new transforms for structured and distinct user-defined types (UDTs).

Transform Group Macros

You can use the following macros to find the transform group for a UDT (or CDT), or the transform group settings for a user, profile, or current session.

Macro Description
SYSUDTLIB.HelpCurrentUserTransforms Lists the transform group settings of the current logon user.
SYSUDTLIB.HelpCurrentSessionTransforms Lists the transform group settings of the current session.
SYSUDTLIB.HelpUserTransforms(User) Lists the transform group settings for a specific user.
SYSUDTLIB.HelpCurrentUDTTransform(UDT) Lists the transform group settings of the current session for the specified UDT.
SYSUDTLIB.HelpUDTTransform(User,UDT) Lists the transform group for a UDT for a user.
SYSUDTLIB.HelpProfileTransforms(Profile) Lists the transform group settings for a specific profile.

SYSUDTLIB.HelpProfileTransform(Profile,UDT)

 Lists the transform group for a UDT for a profile.

For more information about these macros, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

Related Information

  • XSLT Transformation
  • In Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144:
    • CREATE PROFILE
    • MODIFY PROFILE
    • CREATE USER
    • MODIFY USER
    • SET TRANSFORM GROUP FOR TYPE