In the Table Function view of the IBM® OLE DB Table
Function Designer, you define the OLE DB table function, specify an
OLE DB provider, and choose whether to create an optional DB2® table or
view of the table function.
OLE DB Table Function Definition
In this section, you specify the information that identifies
the OLE DB table function.
Function name
Type a name for the OLE DB table function. The name cannot
exceed 128 characters.
Schema name
Type a schema name for the OLE DB table function. If you do
not specify a schema, the default value is the name of the
schema that is obtained from current data connection.
Specific name
Type a specific name for the new OLE DB table function. This is a
unique name that the server uses to identify the function. This field
automatically fills in as you type in the Function name
field. If you do not specify a unique name, the designer generates
one.
Comment
Type comments for the table function.
OLE DB Provider
In this section, you identify the OLE DB provider.
The connection to the OLE DB provider occurs when you move
to the Function Data view in the designer.
Specify an OLE DB connection string
If you select this option, type the OLE DB provider connection
string. The connection string is composed of a database type
specifier and zero or more parameters separated by semicolons.
The parameters that are included in the connection string are
specific to the particular OLE DB provider that you use.
Test Connection
Uses the connection string that you specify to test the
connection to the OLE DB provider.
A message indicates success or failure.
Select an OLE DB connection
If you select this option, select an existing OLE DB connection
from the list, or click Add Connection to specify a new
connection.
Choose an existing connection
Select an OLE DB connection from the list of active OLE DB
connections.
Add Connection
Opens the Add Connection window, where you can define a new
OLE DB connection.
Important: You can select from a wide range of
OLE DB providers in the Add Connection window. However, you
can create OLE DB table functions only for the OLE DB providers
that are listed in OLE
DB Providers.
In particular, note that the IBM OLE DB provider for DB2
(IBMDADB2) is not included in the list. OLE DB table functions
cannot connect to a DB2 database.
Options
In this section, you indicate whether to create a new table, a view
of the table function, or both, and then specify the information for
the options that you select.
If you create a table or a view of the table function, the objects are
saved in the same schema as the OLE DB table function.
Create a corresponding table function view
Select to create a DB2 view for the OLE DB table
function. Using a table function view can simplify access
to the OLE DB data.
View name
Type the name of the DB2 view for the table
function.
Comment
Type comments for the table function view.
Create a new table and import the function data into it
Select to create a DB2 table and insert the OLE DB table function
data into it. Use this option if you want to permanently
import the OLE DB data into DB2.