Run the SQL statements in the right hand panel.

Scenario: One lucky employee
A company that produces gambling equipment for casinos is running a promotion for its full-time employees. Each month their DB2 database will randomly pick the name of one lucky full-time employee to be rewarded with a cash prize.

To support this lottery, the database has a few specifications:


Please note the order of CREATE commands:


This demonstrates the ability of DB2 9.7 to create objects tolerant of certain errors, like a missing object. Similarly, DB2 9.7 allows certain errors in SQL Inline Functions.

After running the SQL statements, you will see several errors in the Console - lower right panel. Despite the failure messages, the commands did work. Warnings were returned to inform you that dependent objects have not yet been created.