In the Function Data view of the IBM® OLE DB Table Function Designer,
you select the data source for the table function, select the columns
of data that you want the table function to return, and specify
properties for the returned data columns.
Source Data
In this section, you select the data source for the OLE DB table
function.
Access source data by using a table
Specifies that the table function is to select the data
from an OLE DB table.
Table name
Type the name of the OLE DB table, or select it from the
tables list. A message indicates success or failure.
Access source data by using an SQL query
Specifies that the table function is to return data as the
result of an SQL query that is run on the OLE DB provider.
Type the required SQL query according to the SQL syntax
that is supported by the OLE DB provider that you are using.
Query Builder
Opens the Visual Studio Query Builder, where you can
graphically build an SQL SELECT statement. When you
close the Query Builder, the SQL code in the Query Builder
is automatically pasted in the box at the insertion
point.
Run SQL
Runs the SQL statement that is shown in the query.
Sample Data
After you specify the source data for the table function, in this
section, you can see up to 25 rows of sample data from the table
function.
Data Columns
In this section, you select the columns that you want the table
function to return from the OLE DB data columns.
Available Columns
Shows the available data columns for the selected OLE DB
provider table. To add a data column to the Selected
Columns list, select it in this list and then click
the left arrow button.
Name
Shows the names of the OLE DB data columns.
Type
Shows the data type for each of the OLE DB data
columns.
Selected Columns
Shows the columns that you select for the table function
to return. To change the order of a column in the list,
select the column, and then click the up or down arrow
button.
To remove a column from the list, select the column,
and then click the left arrow button.
Column Mapping
In this section, you review the mapping of the DB2 data
types to the OLE DB data types for the columns that the table
function returns.
You can change the DB2 data type of a column to a data type
that is valid
for the OLE DB data type.
You can also change other DB2 properties that are associated
with a mapped OLE DB column.
Column Type Mappings
Shows the names of the OLE DB data columns,
the data type for each of the columns, and
the corresponding DB2 SQL type that each
of the columns will be mapped to. You
can change the order of the columns that the
table function returns.
Name
Shows the names of the OLE DB data columns.
OLE DB Type
Shows the data type for each of the OLE DB data
columns that you selected in the Data Columns
section.
DB2 Type
Shows the corresponding DB2 type that each of
the OLE DB data columns will be mapped to.
Column Properties
Shows the property values for the column that is selected
in the Column Type Mappings list. An unavailable
property is a limitation of the database that you are using.
Select a property to see its description in the box under
the properties list. If the description exceeds the size of
the box, hover the mouse pointer over the last line of text
in the box. After a brief pause, the full description is
shown in a ScreenTip.