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.