Integrating DB2 Universal Database for iSeries

288 Pages·2005·3.13 MB·English

Front cover

Integrating DB2 UUnniivveerrssaall

Database ffoorr iiSSeerriieess wwiitthh
Miccrroossoofftt AADDOO ..NNEEETTT
Discover the power of ADO .NET Data
Providers for the iSeries
Learn best practices, performance
tuning, and migrating from OLE DB
Master iSeries .NET
programming
Hernando Bedoya
Carlos Carminati
Lorie DuB ois
Jarek Miszczyk
Ajit Mungale
ibm.com/redbooks

International Technical Support Organization

Integrating DB2 Universal Database for iSeries with
Microsoft ADO .NET

April 2005

SG24-6440-00
Note: Before using this information and the product it supports, read the information in “Notices” on
p agevii.

First Edition (April 2005)
This edition applies to Version 5, Release 3, Modification 0 of OS/400 (product number 5722-SS1).
© Copyright International Business Machines Corporation 2005. All rights reserved.
Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule
Contract with IBM Corp.
C ontents

Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .vii
Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
The team that wrote this redbook. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Become a published author. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .x
Comments welcome. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
Part 1. Background. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 1. Introduction to DB2 UDB for iSeries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
1.1 An integrated relational database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
1.2 DB2 UDB for iSeries: an overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
1.2.1 DB2 UDB for iSeries basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
1.3 Connectivity options to DB2 UDB for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.3.1 Multiplatform connectivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.3.2 Windows platform connectivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
1.4 DB2 UDB for iSeries sample schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Chapter 2. Introduction to the Microsoft.NET framework. . . . . . . . . . . . . . . . . . . . . . . 11
2.1 Description of .NET. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
2.1.1 Architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
2.1.2 Platform support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
2.2 Common Language Runtime (CLR) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.2.1 Runtime execution environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.3 Class libraries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Chapter 3. ADO .NET object hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
3.1 Overview of ADO .NET. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
3.1.1 Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
3.1.2 Command. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
3.1.3 DataReader. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
3.1.4 DataAdapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
3.1.5 DataSet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
3.2 Connected mode. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
3.3 Disconnected mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Part 2. Providers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Chapter 4. IBM DB2 UDB for iSeries .NET provider. . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
4.1 Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
4.2 IBM.Data.DB2.iSeries architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
4.2.1 ADO.NET interfaces. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
4.2.2 Host server jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
4.2.3 Supported features. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
4.2.4 Unsupported features. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
4.3 Before we begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
4.3.1 PC setup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
4.3.2 Host setup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
4.4 Getting started. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
© Copyright IBM Corp. 2005. All rights reserved. iii
4.4.1 Displaying the technical reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

4.4.2 Starting Visual Studio .NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
4.4.3 Adding an assembly reference to the provider . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

4.4.4 Adding a namespace directive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
4.5 Provider basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

4.5.1 A simple connection example. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
4.5.2 iDB2Connection and ConnectionString properties . . . . . . . . . . . . . . . . . . . . . . . . 48
4.5.3 iDB2Command properties and methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
4.5.4 Using parameters in your SQL statements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
4.5.5 Calling stored procedures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
4.5.6 Choosing your execute method . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
4.5.7 Provider data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
4.5.8 Handling exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
4.6 Common tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107
4.6.1 A DataReader example. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107
4.6.2 A simple DataAdapter with CommandBuilder example . . . . . . . . . . . . . . . . . . . 110
4.6.3 Using transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116
4.6.4 Calling a program by wrapping it in a stored procedure . . . . . . . . . . . . . . . . . . . 120
4.6.5 Calling a program or CL command using QCMDEXC . . . . . . . . . . . . . . . . . . . . 120
4.6.6 Choosing between iDB2DataReader and iDB2DataAdapter . . . . . . . . . . . . . . . 127
4.7 Advanced topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129
4.7.1 Internationalization and support for multiple languages . . . . . . . . . . . . . . . . . . . 129
4.7.2 Using large objects (LOBs). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132
4.7.3 Updating DataSets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136
4.7.4 Using iDB2CommandBuilder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139
4.7.5 Using DataLinks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141
4.7.6 Connection pooling. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143
4.7.7 Deploying your application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146
4.8 Coding for performance and best practices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146
4.9 Migrating from ADO and OLE DB to ADO.NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
4.9.1 ADO objects and how they map to ADO.NET objects . . . . . . . . . . . . . . . . . . . . 149
4.9.2 ADO recordsets versus ADO.NET DataReaders and DataAdapters . . . . . . . . . 150
4.9.3 Updating tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
4.9.4 Mapping OLE DB properties to ADO.NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
4.9.5 Examples showing an OLE DB application rewritten to use ADO.NET . . . . . . . 152
4.10 Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166
4.10.1 Handle exceptions using try/catch blocks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166
4.10.2 Make sure your server jobs are running . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167
4.10.3 Use provider traces via the cwbmptrc utility . . . . . . . . . . . . . . . . . . . . . . . . . . . 167
4.10.4 Enable server-side diagnostics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
4.10.5 Use communication traces via the cwbcotrc utility . . . . . . . . . . . . . . . . . . . . . . 168
4.10.6 Overriding your ConnectionString. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
4.10.7 Gathering information for IBM Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169
4.11 Writing code for provider independence. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171
4.11.1 Writing provider-independent code with ADO.NET 1.0 and 1.1 . . . . . . . . . . . . 174
4.11.2 Writing provider-independent code with ADO.NET 2.0. . . . . . . . . . . . . . . . . . . 175

Chapter 5. IBM DB2 for LUW .NET provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177
5.1 DB2 Connect overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
5.2 Installing and configuring DB2 Connect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
5.2.1 Host server jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
5.2.2 Prerequisites. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179
5.2.3 Installation procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179
iv Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET
5.2.4 Connecting to an iSeries database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

5.3 IBM DB2 Development Add-In overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182
5.3.1 Registering the IBM DB2 Development Add-In. . . . . . . . . . . . . . . . . . . . . . . . . . 183

5.3.2 Unregistering the IBM DB2 Development Add-In . . . . . . . . . . . . . . . . . . . . . . . . 183
5.3.3 DB2 Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184

5.3.4 DB2 Database Project type. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184
5.3.5 IBM Explorer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186
5.4 IBM DB2 data controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186
5.5 LUW provider features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194
5.5.1 Classes to implement ADO.NET interfaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194
5.5.2 Data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196
5.5.3 Unsupported features. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196
5.6 Getting started. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
5.6.1 Starting Visual Studio .NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
5.6.2 Displaying the technical reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198
5.6.3 Adding an assembly reference to the provider . . . . . . . . . . . . . . . . . . . . . . . . . . 198
5.6.4 Adding a namespace directive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199
5.6.5 Using the DB2Connection object and the ConnectionString. . . . . . . . . . . . . . . . 199
5.6.6 Using the DB2Command object . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201
5.6.7 Using the DB2DataReader object. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202
5.6.8 Using the DB2DataAdapter object . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203
5.7 Advanced topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204
5.7.1 Using large objects (LOBs). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204
5.7.2 Using the DB2CommandBuilder object. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207
5.7.3 Performing transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209
5.8 Best practices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223
5.8.1 Connection pooling. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223
Chapter 6. Selecting the .NET provider. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225
6.1 ODBC .NET Data Provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226
6.2 OLE DB .NET Data Provider. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229
6.3 Provider performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230
6.4 Conclusions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234
Part 3. Scenarios. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235
Chapter 7. ASP .NET scenario (Web forms) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237
7.1 An overview of ASP.NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
7.1.1 ASP .NET Web page (Web form). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
7.1.2 How does ASP .NET work? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239
7.1.3 Configuration files in ASP .NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
7.2 Web controls. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241
7.3 Using the IBM DB2 UDB for iSeries .NET provider. . . . . . . . . . . . . . . . . . . . . . . . . . . 242
7.4 Using the IBM DB2 for LUW .NET provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249
Appendix A. Sample programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257
Samples for the IBM DB2 UDB for iSeries .NET provider . . . . . . . . . . . . . . . . . . . . . . . . . 258
Sample for the IBM DB2 for LUW .NET provider. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259
Appendix B. Additional material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261
Locating the Web material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261
Using the Web material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261
System requirements for downloading the Web material . . . . . . . . . . . . . . . . . . . . . . . 261
How to use the Web material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 262
Contents v
Related publications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

IBM Redbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263
Other publications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

Online resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263
How to get IBM Redbooks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264

Help from IBM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265

vi Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET
N otices

This information was developed for products and services offered in the U.S.A.
IBM may not offer the products, services, or features discussed in this document in other countries. Consult
your local IBM representative for information on the products and services currently available in your area. Any
reference to an IBM product, program, or service is not intended to state or imply that only that IBM product,
program, or service may be used. Any functionally equivalent product, program, or service that does not
infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to
evaluate and verify the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject matter described in this document. The
furnishing of this document does not give you any license to these patents. You can send license inquiries, in
writing, to:
IBM Director of Licensing, IBM Corporation, North Castle Drive Armonk, NY 10504-1785 U.S.A.
The following paragraph does not apply to the United Kingdom or any other country where such provisions are
inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS
PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT,
MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of
express or implied warranties in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made
to the information herein; these changes will be incorporated in new editions of the publication. IBM may make
improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time
without notice.
Any references in this information to non-IBM Web sites are provided for convenience only and do not in any
manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the
materials for this IBM product and use of those Web sites is at your own risk.
IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring
any obligation to you.
Information concerning non-IBM products was obtained from the suppliers of those products, their published
announcements or other publicly available sources. IBM has not tested those products and cannot confirm the
accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the
capabilities of non-IBM products should be addressed to the suppliers of those products.
This information contains examples of data and reports used in daily business operations. To illustrate them
as completely as possible, the examples include the names of individuals, companies, brands, and products.
All of these names are fictitious and any similarity to the names and addresses used by an actual business
enterprise is entirely coincidental.
COPYRIGHT LICENSE:
This information contains sample application programs in source language, which illustrates programming
techniques on various operating platforms. You may copy, modify, and distribute these sample programs in
any form without payment to IBM, for the purposes of developing, using, marketing or distributing application
programs conforming to the application programming interface for the operating platform for which the sample
programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore,
cannot guarantee or imply reliability, serviceability, or function of these programs. You may copy, modify, and
distribute these sample programs in any form without payment to IBM for the purposes of developing, using,
marketing, or distributing application programs conforming to IBM's application programming interfaces.

© Copyright IBM Corp. 2005. All rights reserved. vii
Trademarks

Th e following terms are trademarks of the International Business Machines Corporation in the United States,
other countries, or both:

AIX® i5/OS™ Rational®
AS/400® IBM® Redbooks™
DB2 Connect™ ibm.com® Redbooks (logo) ™
DB2 Universal Database™ iSeries™ WebSphere®
DB2® Operating System/400® XDE™
DRDA® OS/390® z/OS®
Eserver® OS/400®
eServer™ PartnerWorld®
The following terms are trademarks of other companies:
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems,
Inc. in the United States, other countries, or both.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the
United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Linux is a trademark of Linus Torvalds in the United States, other countries, or both.
Other company, product, and service names may be trademarks or service marks of others.

viii Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET