Examples: Specifying the INLINE LENGTH for an XML Type - 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 following examples show XML type declarations with and without the INLINE LENGTH specification.

CREATE TABLE xmlTable1(id INTEGER,
   /* non-LOB */       xml1 XML(64000));
CREATE TABLE xmlTable2(id INTEGER,
   /* non-LOB */       xml1 XML(100),
   /* LOB */           xml2 XML,
   /* LOB */           xml3 XML INLINE LENGTH 30000);

The following is exactly the same as the example for xmlTable2, but with a different syntax.

CREATE TABLE xmlTable3(id INTEGER,
   /* non-LOB */       xml1 XML(100) INLINE LENGTH 100,
   /* LOB */           xml2 XML,
   /* LOB */           xml3 XML INLINE LENGTH 30000);
CREATE TABLE xmlTable4(id INTEGER,
   /* non-LOB */       xml1 XML(30000) INLINE LENGTH 30000,
   /* LOB */           xml2 XML INLINE LENGTH 100);
CREATE TABLE xmlTable5(id INTEGER,
   /* LOB */           xml1 XML(64000) INLINE LENGTH 100);