DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
Represents XML data from a DB2 data source.
System.Object
System.ValueType
IBM.Data.DB2Types.DB2Xml
[Visual Basic]
NotInheritable Public Class DB2Xml
Inherits ValueType
[C#]
public sealed class DB2Xml : ValueType
[C++]
public __gc __sealed class DB2Xml : public ValueType
[JScript]
public class DB2Xml extends ValueTypeSupported in: IBM® iSeries® Version 7 Release 1 with DB2® Version 9.7 Fix Pack 5
Informix® data servers do not support this class.
[C#] The function in this example prints the contents of an XML column, named DESCRIPTION, from a table called PRODUCT. To retrieve the XML column data, this example uses the DB2DataReader.GetDB2Xml method, and passes the XML data to a DB2Xml object.
[C#]
public static void ReadXmlColumn(DB2Connection conn)
{
DB2Xml xmlColValue;
String xmlString;
String cmdSQL = "SELECT DESCRIPTION FROM product WHERE pid='100-101-01'";
DB2Command cmd = new DB2Command(cmdSQL, conn);
DB2DataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
xmlColValue = reader.GetDB2Xml(0);
xmlString = xmlColValue.GetString();
Console.WriteLine(" {0} \n", xmlString);
}
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
reader.Close();
}
}Any public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.