IBM Database Add-Ins for Visual Studio  

Enabling DB2 Database Table Functions

With the IBM® Database Add-Ins for Visual Studio, you can define OLE DB table functions that access OLE DB data sources and extract data from them. You use the IBM OLE DB Table Function Designer to create OLE DB table functions.

The IBM OLE DB Table Function Designer uses table functions that are provided by the DB2® database engine. Before you create your first OLE DB table function, you must enable the use of these functions by registering the db2olefn DLL.

To enable the DB2 database table functions:

  1. Quit Visual Studio if it is running.
  2. Open an MS-DOS window. On your desktop, click Start > Programs > Accessories > Command Prompt.
  3. Under the directory where you installed DB2, change to the SQLLIB\FUNCTION directory.
  4. Enter the following command at the DOS prompt:

       regsvr32 db2olefn.dll

  5. Close the MS-DOS window.
  6. Start Visual Studio.

You can now open the IBM OLE DB Table Designer and create OLE DB table functions.

See Also

Developing OLE DB Table Functions | Creating OLE DB Table Functions | OLE DB Table Functions


.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.