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.

Before you begin

Before you run the wizard, ensure that you have completed the appropriate setup steps as described in the DB2® for Linux®, UNIX®, and Windows® information center: OLE DB user-defined table functions.

Enable the OLE DB templates that are provided with the product on the Routines -Templates Preferences page. For more information about routine templates see the related link.

Procedure

To create a UDF for OLE DB:

After you complete the prerequisites, create the function using the New User-Defined Function wizard.

Results

The user-defined function is created and added to the data development project that you specified.

What to do next

Deploy the function to a database.

Feedback