Send feedback on this topic.
Teradata.Client.Provider
CreateXmlReader Method



Teradata.Client.Provider Namespace > TdXml Class : CreateXmlReader Method
Creates an XmlReader that is used by an application to retrieve the Xml data from a Teradata Database.
Syntax
'Declaration
 
Public Function CreateXmlReader() As XmlReader
'Usage
 
Dim instance As TdXml
Dim value As XmlReader
 
value = instance.CreateXmlReader()
public XmlReader CreateXmlReader()
public:
XmlReader^ CreateXmlReader(); 

Return Value

A XmlReader instance is returned.
Remarks

When a XmlReader is created by the provider, a request on the existing connection is opened. The Advanced SQL Engine only allows 16 open requests per a connection. Therefore, there can only be up to 16 XmlReaders that are opened at the same time. This limit also applies when a combination of LOBs and XmlReaders are concurrently opened.

Because the XmlReader uses provider resources to access the database, it is highly recommended that Xml.XmlReader.Close be called before a XmlReader instance is disposed during garbage collection. This will guarantee that the request that was created will be closed and that other resources will be cleaned up.

The conformance level (Xml.ConformanceLevel) has been set to ConformanceLevel.Fragment. The reason for this is that the SQL Xml data type supports both Xml documents and fragments.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

See Also

Reference

TdXml Class
TdXml Members