16.20 - XML Data Type Syntax - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

Syntax



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
Teradata Database 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.