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 following directory: installdir\plugins\com.ibm.datatools.sqlbuilder_version\samples, where installdir is your installation 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.