XML Data Type Syntax - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

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.