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.