| || |
|About this tutorial||Page 1 of 5|
This tutorial demonstrates the development of DB2
server-side objects such as tables, views, indexes, triggers, procedures, and
functions using the IBM Explorer component of the DB2 "Stinger" Development Add-In for Visual Studio Technical Preview. To show the ease of
building these objects, this tutorial guides you through the steps required to develop
a sample items inventory management application for a small company using the
DB2 "Stinger" Development Add-In for Visual Studio Technical Preview.
You will learn how to:
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 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.