Databases Reference
In-Depth Information
<newspaper name="San Francisco Post">The best mystery thriller of the
year.</newspaper>
</CriticsReview>
</reviews>
</movie>
<movie id = "456">
<reviews>
<UserReview>
<user name ="Andy">Three is a crowd, yet there are not enough stars
to support this catastrophe.</user>
<user name ="Linda">Almost jokeless and at times nearly
incomprehensible...</user>
</UserReview>
<CriticsReview>
<newspaper name="ABC Times">The best mystery thriller of the year.
</newspaper>
<newspaper name="San Francisco Post">The best mystery thriller of the
year. </newspaper>
</CriticsReview>
</reviews>
</movie>
<movie id = "567">
<reviews>
<UserReview>
<user name ="Andy">Three is a crowd, yet there are not enough stars
to support this catastrophe.</user>
<user name ="Linda">Well here goes! We caught the advance screening
here</user>
</UserReview>
<CriticsReview>
<newspaper name="ABC Times">The best mystery thriller of the
year.</newspaper>
<newspaper name="San Francisco Post">The best mystery thriller of the
year.</newspaper>
</CriticsReview>
</reviews>
</movie>
A.2 Setting up the database
Example A-3 on page 302 shows the script to set up the database for the Movie
review example. This is the only script needed to be run to set up the database
used in the example throughout Chapter 2, “Application development with DB2
pureXML” on page 49. Run the script movies.db2 as below:
db2 -td@ -vf movies.db2
Search WWH ::
Custom Search