This tutorial demonstrated the ease of creating and testing
database schema and logic objects using DB2 "Stinger" Development Add-In for Visual Studio Technical Preview. Many new
functionally rich wizards have been added to allow you to create tables, views,
indexes, triggers, procedures, and functions in an ad-hoc fashion using DB2
Using the easy to follow instructions for building the
sample inventory application, you have learned how to do the following from the
a local DB2 database.
local and remote DB2 data connections.
- Develop DB2 CLR methods using ADO.NET and the DB2 managed provider.
DB2 tables with some advanced column value options and check constraints
DB2 views, scalar SQL functions, table SQL functions, and SQL procedures
DB2 triggers for tracking changes from a table in a history table using
table column definitions into other new schema objects.
details for tables (columns, triggers, and indexes) and views (columns and
and update data for tables and views.
procedures and functions.
All of the tasks required to build this application were done
from within the IDE itself, demonstrating the tight integration of the DB2
application development tooling in this environment.