Create views and triggers with IBM DB2 Development Add-In for .NET

Level: Intermediate

Tammi Khaleel (tkhalee@us.ibm.com), Software Engineer, IBM
Chenhong Xia (xia@us.ibm.com), Human Factors Engineer, IBM

24 Aug 2004

	Register now or sign in using your IBM ID and password.

This tutorial, a follow-on to a previous tutorial, explores the features of the IBM® DB2® Development Add-In for Microsoft Visual Studio .NET. More specifically, we create a view with two base tables. In addition, we create three INSTEAD OF triggers that will insert, update, and delete rows in the view.

The insert, update, and delete actions will propagate into the two base tables. You must create these base tables, using the specifications detailed in the Using the IBM DB2 Development Add-In for Microsoft Visual Studio, Part 1 tutorial.

Prerequisites

To complete this tutorial, the following software and setup are required:

• IBM DB2 Universal Database V8.2, with the SAMPLE database created (issue db2sampl)
• Microsoft Visual Studio .NET 2003
• Create two tables, using the specifications detailed in the Using the IBM DB2 Development Add-In for Microsoft Visual Studio, Part 1 tutorial.

System requirements

None.

Duration

2 hours

Formats

Share this.... Digg this story del.icio.us Slashdot it!

Back to top