Setup procedure and sample data - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 296

A.1 Example data
Example A-1 shows the movie XML data, with a total of five movies in the XML.
Example: A-1 Movie.xml
<?xml version="1.0" encoding="UTF-8"?>
<movie id = "123">
<heading>
<title>Peterson's New Life </title>
<rating>****</rating>
</heading>
<movie-details>
<genres>Drama, Romance and Remake</genres>
<MPAArating>PG13</MPAArating>
<country>US</country>
<year>2006</year>
<running-time>1 hr. 49 minutes</running-time>
<production>
<studio>JJ Studio</studio>
</production>
</movie-details>
<synopsis>
After losing their 12-year-old son, Steve and Maggie Peterson moved to
a small town. The unexpected visiting of the granddaughter from the
next door neighbor has brought them surprise after surprise.
</synopsis>
<credits>
<writer>Michael Sileur</writer>
<director>John and Anne Tate</director>
<photography>Charles Govasky</photography>
<actors>
<actor special="yes" type="lead" gender="M">Sam Wilson</actor>
<actor type="lead" gender="F">Kate Henderson</actor>
<actor type="lead" gender="M" special="yes">Michael Glaski</actor>
<actor gender="M">Matt Warrich</actor>
<actor gender="M">Chris Rogen</actor>
<actor gender="F">Amanda Johnson</actor>
<actor gender="M">Bill Hagen</actor>
</actors>
</credits>
</movie>
<?xml version="1.0" encoding="UTF-8"?>
<movie id = "234">
<heading>
<title>Paradise Regained</title>
<rating>*****</rating>