You can use the workbench to develop OLE DB table functions
that create DB2® tables. You
can also create views of the table functions.
OLE DB table functions
Microsoft® OLE
DB is a set of application programming interfaces through which applications
can uniformly access data that is stored in diverse information sources.
OLE DB is conceptually divided into OLE DB consumers and OLE DB providers.
An OLE DB provider is a software component that exposes OLE DB interfaces,
and an OLE DB consumer is the application that accesses the OLE DB
interfaces and consumes the data.
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.
Supported SQL Data Types in OLE DB
The following table shows how OLE DB data types map to
the DB2 data types. The OLE
DB Table Function wizard defines the appropriate RETURNS TABLE columns
in your OLE DB table function, based on the values in this table.