Use the Create OLE DB Table Function wizard to create an
OLE DB user-defined table function that allows you import data from
a database that supports the OLE DB format.
Prerequisites:- DB2® Universal Database™ for Linux®, UNIX®, and Windows®, Enterprise Server Edition (Version
8 and later)
- OLE DB 2.0 or later, available from Microsoft® at http://www.microsoft.com.
If you attempt to invoke an OLE DB table function without first installing
OLE DB, DB2® issues SQLCODE -465,
SQLSTATE 58032, reason code 35. For the system requirements and OLE
DB providers available for your data sources, refer to your data source
documentation. For the OLE DB specification, see the Microsoft OLE DB 2.0 Programmer's
Reference and Data Access SDK, Microsoft Press,
1998.
- db2olefn.dll must be registered on your computer.
To register this DLL file, enter regsvr32 DB2installdir\sqllib\function\db2olefn.dll on
a command line, where DB2installdir is the root
directory where you installed DB2.
To create a UDF for OLE DB:
- Switch to the Data perspective.
- Click File > New > Other to open
the New dialog.
- Select Data and choose User-Defined
Function.
- Click Next. The
wizard opens.
- On the Specify a Project page, choose
to use a new project or select an existing data development project.
- Click Next. The Name
and Language page opens.
- In the Language field, select OLE
DB.
- Complete the necessary steps of the wizard.
- Click Finish.
The user-defined function is created and added to the data
development project that you specified, and the user-defined function
is deployed and registered on the database server.