SQL Reference

Appendix G. Sample Database Tables

This appendix shows the information contained in the sample tables of the sample database SAMPLE, and how to create and remove them.

Additional sample databases are provided with DB2 Universal Database to demonstrate business intelligence functions, and are used in the business intelligence tutorial. However, only the contents of the sample database SAMPLE are described in this appendix. Refer to the Data Warehouse Center Administration Guide for more information about the business intelligence sample databases.

The sample tables are used in the examples that appear in this manual and other manuals in this library. In addition, the data contained in the sample files with BLOB and CLOB data types is shown.

The following sections are included in this appendix:.

The Sample Database
To Create the Sample Database
To Erase the Sample Database
CL_SCHED Table
DEPARTMENT Table
EMPLOYEE Table
EMP_ACT Table
EMP_PHOTO Table
EMP_RESUME Table
IN_TRAY Table
ORG Table
PROJECT Table
SALES Table
STAFF Table
STAFFG Table
Sample Files with BLOB and CLOB Data Type
Quintana Photo
Quintana Resume
Nicholls Photo
Nicholls Resume
Adamson Photo
Adamson Resume
Walker Photo
Walker Resume.

In the sample tables, a dash (-) indicates a null value.


[ Top of Page | Previous Page | Next Page ]