The Teradata Database began to support the Xml type beginning with the 14.10 release. The Xml type allows Xml documents and fragments to be inserted and queried using SQL statements. Refer to the Teradata Database 14.10 manual SQL Reference: Data Types and Literals for more information on the Xml type.
The equivalent provider specific type that is supported by the .NET Data Provider For Teradata to the Xml type is TdXml. TdXml does not support any public constructors. An instance of TdXml is returned to an application when calling TdDataReader.GetTdXml.
Xml can be retrieved either in deferred or inline modes. The following TdDataReader methods can be used to retrieve Xml:
Xml can also be inserted or updated by specifying the TdParameter.TdType as TdType.Xml and setting TdParameter.Value to one of the following types:
Refer to the TdXml Reference for information on restrictions when using TdXml.
Retrieving Xml from a Teradata Database
Sending Xml To a Teradata Database