The Advanced SQL Engine supports 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 "SQL Data Types and Literals" manual 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:

• GetTdXml -- can only be used in deferred mode.
• GetXmlReader -- can only be used in deferred mode.
• GetChars -- can be used in either deferred or inline modes.
• GetString -- can be used in either deferred or inline modes.
• GetFieldValue<XmlReader> -- can only be used in deferred mode.

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:

• System.Xml.XmlReader
• System.IO.TextReader
• String
• Character Array

Refer to the TdXml Reference for information on restrictions when using TdXml.

In This Section

Retrieving Xml from a Teradata Advanced SQL Engine

Sending Xml To a Teradata Advanced SQL Engine

Xml Schema Information