This section describes the steps required to create the following database schema objects:
- The Inventory, and the InventoryHistory tables
- The InventoryName index
- The LowInventory view
Using double quotes for SQL identifier
Throughout this section, use double quotes
for various SQL identifiers, such as table names, column names, view names, ...etc. Double quotes preserve the lower/upper case mixing in these
identifiers, and support blanks when and where required.
If you don't use quotes,
SQL identifiers will automatically be uppercase.
Using the DB2 database project:
Note that the DB2 Project
Selection step is not included in most of the wizards used in the tutorial.
This step allows you to specify a target DB2
database project for which to add the script files the get generated to create
the various DB2 objects. I would strongly
recommend that you use this option, as you be able to
save your script files for further editing and re-deployment to other database