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\IBMIMShared\plugins\com.ibm.datatools.sqlbuilder.tutorial.doc_version.jar,
where shared-resources-directory is your shared
resources directory.
For IBM Data Studio, the JAR is
in the zip file that you download when installing help content locally.
You can download the zip file at this web site. The file is in the directory plugins\.

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.