XML Type Transform | Teradata Vantage - XML Type Transform - Advanced SQL Engine - Teradata Database

XML Data Type
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
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 Topics

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