table function

GET_DBM_CONFIG Table function Returns database manager configuration information in a table with two rows and a column for each parameter.

Second, the NEW_OL _LOCAL table function, as you will see later, actually writes to a table.

In the query access plan shown in Listing 9, notice a join between the table EMPLOYEE and a table function, GENROW.

The output of the wrapper table function matches exactly the output from the monitoring table function with one additional column.

First, the NEW_OL _LOCAL table function really returns only one row at a time.

The mysql_field_table() function returns the name of the table where a specified field is located.

Create a table function that wraps the underlying monitoring table function and takes deltas against the baseline data stored in the CGTT.

Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).

XMLTABLE is a SQL table function that returns a table from the evaluation of XQuery expressions on an XML document.

The MON_GET_INDEX table function and db2pd utility provide the same index metrics (number of index scans and index only scans).

The procedure simply selects from the monitoring table function and inserts the data returned into the CGTT in order to take a baseline.

Using a correlated join, the NEW_OL_LOCAL SQL Table Function processes each item in the list separately.

Creating a table function that returns multiple values isn't much more difficult.

Listing 20 shows a sample of how to call the MON_GET_INDEX table function.

The table function to find the number of users connected to DB2 is shown in Listing 3.

The monitoring data returned by this table function is relative to the baseline, taken at 1: 00 p. m.

A table function returns a table with many rows and columns.

The table, function, and thread types are all references.

Listing 4 defines a table function that wraps the MON_GET_TABLE table function.

At 2: 00 p. m. , on the same connection, query the monitoring data for the TEST. EMPLOYEE table using the GET_TABLE_DELTA table function.

For example, all the steps not involving the order lines have been unified into one SQL table function.

However, if you are using DB2 Version 9. 7, you can retrieve the same information by querying the new MON_GET_INDEX table function.

In Figure 9 you can see that I'm calling the same kind of information by using a view instead of a table function in the previous figure

Improved Method of the Table Function in Analysis of Nonlinear SD Model Structure

To create the cluster description query subject from the DB2 table function