There are two types of UDFs in DB2: scalar and table functions.
在DB 2中有两种类型的UDF：标量函数(scalar function)和表函数(table function)。
Wrapper table functions that report deltas relative to the baseline data.
报告相对于基线数据的差值的包装器表函数。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样，表函数也可以在SQLselect语句中使用。
If you do not, the script will be unable to define the CGTTs used by the delta table functions.
如果不这样做，脚本就无法定义差值表函数要使用的CGTT。
The functions can be coded to return a single value (for scalar functions) or multiple values (for table functions).
函数可以返回单一值(对于标量函数)或多个值(对于表函数)。
Through correlation, SQL table functions allow a more efficient way of implementing iterations, otherwise done with cursors.
通过关联(correlation)，SQL表函数允许以一种更高效的方式实现迭代，而不是使用游标。
These new table functions are planned to be updated and enhanced with new releases of DB2, while the snapshot interface will not be.
这些新的表功能计划在最新DB2版本中更新和增强，而快照接口将不再更新。
The new table functions are created after the procedure executes. To list the output columns for the table functions, execute the following statements
在执行该过程后创建新的表函数。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE （ 数据更改操作）放入到关联连接的内表中。
All of these functions have one thing in common: When called, each one returns a result set that looks like a DB2 table (which is why we call them table functions).
所有这些函数都有一个共同点：当被调用时，每个函数都返回一个结果集，这个结果集看上去像一个db2表(这正是我们将其称作表函数的原因)。
The three provided table functions can return health-related information for all four monitored object types. These functions are grouped into the following categories.
系统提供的这三个表函数可以为所有被监视的4种对象类型返回与健康有关的信息。
The generated table functions only report the monitor elements that were present in the DB2MonCommon.xsd file at the time that the GENERATE_MON_UDFS procedure was invoked.
在调用 GENERATE_MON_UDFS过程时，已生成的表函数只报告出现在DB2MonCommon.xsd文件中的监控器元素。
You can use DB2 workload Manager (WLM) by writing your own scripts to call the table functions, stored procedures, and event monitors to gather information about the workload.
可以通过编写脚本来使用DB 2WorkloadManager (WLM)，从而调用表函数、存储过程和事件监视器，收集关于工作负载的信息。
This article has shown a procedure that you can use to automatically generate table functions that report event monitor elements captured as an XML document in a relational format.
本文已经显示了一个过程，您可以使用该过程自动生成表函数，其以关系格式报告以XML文档形式捕获的事件监控器元素。
The usage of SQL Table Functions allows you to push procedural logic into the FROM clause of a query.
sql表函数的使用使您可以将过程性逻辑放入到查询的from子句中。
Table functions are powerful because it can make any data source appear like a DB2 table, which can be then used in normal SQL queries, join operations, grouping, and so on.
表函数的功能很强大，因为它可以使任何数据源看起来类似于db2表，然后就可以用于常规的SQL查询、连接操作和分组等。
Table functions are powerful because it can make any data source appear like a DB2 table, which can be then used in normal SQL queries, join operations, grouping, and so on.
表函数的功能很强大，因为它可以使任何数据源看起来类似于db2表，然后就可以用于常规的SQL查询、连接操作和分组等。
应用推荐