The exercises in this tutorial use tables in the VIDEOS
database, which you will create by running a batch file. The batch
file and the source files that contain the data for the VIDEOS database
tables are included increateVideos.zip, which is
in the samples folder of the following JAR file: <installation_directory>\rdz\samples\DB2\SQLQueryTutorial,
where <installation_directory> is the directory
where Rational® Developer
for System z® was installed.

The scripts to create the VIDEOS database
for this tutorial are not currently provided for the Linux operating system. You can create your
own database and follow along with most of the steps in the exercises,
adjusting them as necessary for your database and statements.
To
create the VIDEOS database:
- Open the createVideos.zip file, and extract
the files to a new directory.
- Open a DB2 command
window. In Windows, select
from the Start Menu .
- In the DB2 command
window, change directories to the createVideos\createVideoStore directory.
- Enter the following command: createVideoStore.bat. After messages are displayed that show progress in creating
the database, the following message is displayed:
DB200001 The SQL command completed successfully
Tip: If you do not get a completed successfully message, check
to make sure that DB2 is started
on your workstation. In Windows,
if the DB2 icon in the notification
area has a little red square on it,

then you
need to start the Database Manager. Right click on the icon, select Start
(DB2), and repeat step 4. You should now get a completion
successful message.
- To test the creation of the VIDEOS database, enter the
following commands in the DB2 command
window:
db2 connect to videos
db2 select * from xmltest.rentals
The values in the xmltest.rentals table (which
is part of the VIDEOS database) are listed and displayed in table
format.