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
Summary and resources
  


SummaryPage 1 of 2


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 data connections.

Using the easy to follow instructions for building the sample inventory application, you have learned how to do the following from the IBM Explore:

  • 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 some 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.

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.


Main menuSection menuFeedbackNext
About IBM | Privacy | Legal | Contact