Skip to main content
IBM Skip to main content
spHome | Products & services | Support & downloads | My account
Software > DB2 > DB2 Developer Domain
Developing DB2 schema using IBM Explorer in VS.NET
ZIPPDF (letter)PDF (A4)e-mail
Main menuSection menuFeedbackNext
Before you start
  


About this tutorialPage 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:

  • Create a local DB2 database.
  • Discover local and remote DB2 data connections.
  • Develop DB2 CLR methods using ADO.NET and the DB2 managed provider.
  • Create DB2 tables with advanced column value options and check constraints using wizards.
  • Create DB2 views, scalar SQL functions, table SQL functions, and SQL procedures using wizards.
  • Create DB2 triggers for tracking changes from a table in a history table using wizards.
  • Import table column definitions into other new schema objects.
  • View details for tables (columns, triggers, and indexes) and views (columns and triggers).
  • Retrieve and update data for tables and views.
  • Run procedures and functions.

Main menuSection menuFeedbackNext
About IBM | Privacy | Legal | Contact