Creating DB2 user-defined functions for OLE DB

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:

To create a UDF for OLE DB:

  1. Switch to the Data perspective.
  2. Click File > New > Other to open the New dialog.
  3. Select Data and choose User-Defined Function.
  4. Click Next. The wizard opens.
  5. On the Specify a Project page, choose to use a new project or select an existing data development project.
  6. Click Next. The Name and Language page opens.
  7. In the Language field, select OLE DB.
  8. Complete the necessary steps of the wizard.
  9. 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.

Feedback