The exercises in this tutorial use tables in the VIDEOS
database. You will create the database by running a batch file. The
batch file and the source files that contain the data for the VIDEOS
database tables are included in the createVideos.zip file, which is
in the samples folder of the following JAR file: shared-resources-directory\SDPShared\plugins\com.ibm.datatools.sqlbuilder.tutorial.doc_version.jar,
where shared-resources-directory is your shared
resources directory.

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. Click .
- In the DB2 command
window, change to the createVideoStore directory
under the directory that you extracted the files to.
- 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
- 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, showing you that the database was
created successfully.