-->

An overview of how to use XML Data Type with Db2 for IBM i. Insert, Validate and Serialize XML using DB2 for IBM i, a new enhancement in 7.1. Case where I simply want to store Order XML documents in an SQL column.

XML serialization can take more than one form, from simple to complex. For example, you can serialize a class that simply consists of public fields and properties, as shown in Introducing XML Serialization. The following code examples address various advanced scenarios, including how to use XML serialization to generate an XML stream that conforms to a specific XML Schema (XSD) document.

Serializing a DataSet

Besides serializing an instance of a public class, an instance of a DataSet can also be serialized, as shown in the following code example.

Serializing an XmlElement and XmlNode

You can also serialize instances of an XmlElement or XmlNode class, as shown in the following code example.

Serializing a Class that Contains a Field Returning a Complex Object

If a property or field returns a complex object (such as an array or a class instance), the XmlSerializer converts it to an element nested within the main XML document. For example, the first class in the following code example returns an instance of the second class.

The serialized XML output might resemble the following.

Serializing an Array of Objects

You can also serialize a field that returns an array of objects, as shown in the following code example.

The serialized class instance might resemble the following, if two items are ordered.

Serializing a Class that Implements the ICollection Interface

You can create your own collection classes by implementing the ICollection interface, and use the XmlSerializer to serialize instances of these classes. Note that when a class implements the ICollection interface, only the collection contained by the class is serialized. Any public properties or fields added to the class will not be serialized. The class must include an Add method and an Item property (C# indexer) to be serialized.

Purchase Order Example

You can cut and paste the following example code into a text file renamed with a .cs or .vb file name extension. Use the C# or Visual Basic compiler to compile the file. Then run it using the name of the executable.

This example uses a simple scenario to demonstrate how an instance of an object is created and serialized into a file stream using the Serialize method. The XML stream is saved to a file, and the same file is then read back and reconstructed into a copy of the original object using the Deserialize method.

In this example, a class named PurchaseOrder is serialized and then deserialized. A second class named Address is also included because the public field named ShipTo must be set to an Address. Similarly, an OrderedItem class is included because an array of OrderedItem objects must be set to the OrderedItems field. Finally, a class named Test contains the code that serializes and deserializes the classes.

Golmaal fun unlimited hd 720p movie mkv download. The CreatePO method creates the PurchaseOrder, Address, and OrderedItem class objects, and sets the public field values. The method also constructs an instance of the XmlSerializer class that is used to serialize and deserialize the PurchaseOrder. Note that the code passes the type of the class that will be serialized to the constructor. The code also creates a FileStream that is used to write the XML stream to an XML document.

The ReadPo method is a little simpler. It just creates objects to deserialize and reads out their values. As with the CreatePo method, you must first construct an XmlSerializer, passing the type of the class to be deserialized to the constructor. Also, a FileStream is required to read the XML document. To deserialize the objects, call the Deserialize method with the FileStream as an argument. The deserialized object must be cast to an object variable of type PurchaseOrder. The code then reads the values of the deserialized PurchaseOrder. Note that you can also read the PO.xml file that is created to see the actual XML output.

The XML output might resemble the following.

It is the sequel to WWE SmackDown! Bully ps2 iso highly compressed games free download.

See also

TheXMLSERIALIZE function returns a serialized XML value of the specifieddata type generated from the XML-expression argument.

Notes:

• ¹ The same clause must not be specified more than once.

The schema is SYSIBM. The function name cannot be specifiedas a qualified name.

CONTENT

Specifies that any XML value can be specified and the result ofthe serialization is based on this input value.

XML-expression

Specifies an expression that returns a value of data type XML.The XML sequence value must not contain an item that is an attributenode (SQLSTATE 2200W). This is the input to the serialization process.

AS data-type

Specifies the result type. The implicit or explicit length attributeof the specified result data type must be sufficient to contain theserialized output (SQLSTATE 22001).

VERSION '1.0'

Specifies the XML version of the serialized value. The only versionsupported is '1.0' which must be specified as a string constant (SQLSTATE42815).

EXCLUDING XMLDECLARATION or INCLUDING XMLDECLARATION

Specifies whether an XML declaration is included in the result.The default is EXCLUDING XMLDECLARATION.

EXCLUDING XMLDECLARATION

Specifies that an XML declaration is not included in the result.

INCLUDING XMLDECLARATION

Specifies that an XML declaration is included in the result. TheXML declaration is the string '<?xml version='1.0' encoding='UTF-8'?>'.

AS data-type

Specifies the result data type. The implicit or explicit lengthattribute of the specified result data type must be sufficient tocontain the transformed output (SQLSTATE 22001).

Ifeither the xml-document argument or the xsl-stylesheet argumentis null, the result will be null.

Code page conversion mightoccur when storing any of the previously mentioned documents in aCHAR, VARCHAR, or CLOB column, which might result in a character loss.

The result has the data type specified by the user. AnXML sequence is effectively converted to have a single document nodeby applying XMLDOCUMENT to XML-expression before serializing the resulting XML nodes. If the result of XML-expression canbe null, the result can be null; if the result of XML-expression isnull, the result is the null value.

Notes

• Encoding in the serialized result: The serialized resultis encoded with UTF-8. If XMLSERIALIZE is used with a character datatype, and the INCLUDING XMLDECLARATION clause is specified, the resultingcharacter string containing serialized XML might have an XML encodingdeclaration that does not match the code page of the character string.Following serialization, which uses UTF-8 encoding, the characterstring that is returned from the server to the client is convertedto the code page of the client, and that code page might be differentfrom UTF-8.

  Therefore, applications should avoid direct use ofXMLSERIALIZE INCLUDING XMLDECLARATION that return character stringtypes and should retrieve XML values directly into host variablesto maintain the match between the external code page and the encodingin the XML declaration. If XMLSERIALIZE must be used in this situation,a BLOB type should be specified to avoid code page conversion.

• Syntaxalternative: XML2CLOB(XML-expression) can be specified in place ofXMLSERIALIZE(XML-expression AS CLOB(2G)). It is supported only forcompatibility with previous Db2® releases.