 | Level: Intermediate Abdul Al-Azzawe (abdulh@us.ibm.com), DB2 Tools architect, IBM
17 Aug 2004
Configuring ADO.NET data adapters to call DB2® UDB stored procedures was a complex task prior to the introduction of the DB2 Stinger technology. This tutorial walks you through the steps required to build an application that uses SQL stored procedures to select, insert, update, and delete rows from database tables and views.
Note:
Any of the DB2 server products may be used with this tutorial including: DB2 for z/OS V6 or later, DB2 Distributed Server V8.1 or later,and DB2 UDB for iSeries V5r1 or later.
Prerequisites
You should take this tutorial if you want to learn about:
- Creating new SQL stored procedures directly from the IBM® Explorer.
- Configuring DB2 data adapters to use stored procedures for select, insert, update, and delete operations.
- Defining and altering the result set shape for a data adapter.
- Binding form controls to input parameters of stored procedure commands.
- Generating a data set for a stored procedure based data adapter.
- Binding form controls to a DB2-generated data set.
.
System requirements
The tutorial was built using software from both IBM and Microsoft®:
- IBM DB2 V8.2 Client or DB2 Connect, V8.2
- IBM DB2 V8.2 Application Development Client
- Any one of the following IBM DB2 servers:
- DB2 for z/OS Server V6 or later
- DB2 for iSeries V5r1 or later
- DB2 Distributed Server V8 or later
- Microsoft Windows® 2000, 2003, or XP with the Microsoft.NET® framework V1.1
- Microsoft Visual Studio® 2002 or 2003
Duration
2 hours
Formats html, pdf
| | | |
