XML Data Type Syntax | Teradata Vantage - XML Data Type Syntax - Analytics Database - Teradata Vantage

Teradata Vantage™ - XML Data Type - 17.20

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-01-27
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
Product Category
Teradata Vantage
{ XML | XMLTYPE }
  [ ( maxlength ) ]
  [ INLINE LENGTH integer ]
  [ attributes [...] ]

Syntax Elements

maxlength
A positive integer value followed by an optional multiplier.
The multiplier, if specified, is KkMmGg.
maxlength specifies the maximum length of the data type in bytes. You can define a maximum length on a per instance basis. When specified, the data type is used in a manner analogous to the VARBYTE or BLOB data types.
The length specified only covers the actual data length. The actual storage sizes include additional header information.
The value of maxlength cannot be less than 100 bytes or greater than 2097088000 bytes.
If maxlength is not specified, the default maximum length used is 2097088000 bytes.
INLINE LENGTH integer
A positive integer value which specifies the inline storage size. Data that is smaller than or equal to the inline storage size is stored inside the base row; otherwise, it is stored in a LOB subtable.
The inline length cannot be larger than maxlength.
attributes
The following data type attributes are supported for the XML type:
  • NULL and NOT NULL
  • TITLE
  • NAMED
  • DEFAULT NULL
Vantage does not support column storage or column constraint attributes for the XML type. For more information about the data type attributes, see Teradata Vantage™ - Data Types and Literals, B035-1143.