O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix F. DDL

This appendix contains all the Data Definition Language (DDL) statements for the SAMPLE database and other database objects required to run the examples in this book. The first script is the DDL for the SAMPLE database, which can be created using the methods described in this appendix. The second script has the additional DDL required for the examples and you will have to create those objects manually.

Creating the SAMPLE Database on LUW

The SAMPLE database provided with DB2 on LUW can be created by using one of two methods:

  • Create the database from the First Steps dialog, which launches automatically after installation.

  • Create the database from the command line.

The default schema used for tables in the database will be the user ID ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required