Table functions are called like this.
表函数的调用方法如下。
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 usage of SQL Table Functions allows you to push procedural logic into the FROM clause of a query.
sql表函数的使用使您可以将过程性逻辑放入到查询的from子句中。
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表函数允许以一种更高效的方式实现迭代，而不是使用游标。
Table functions enable you to efficiently use relational operations and the power of SQL on data that is not in an actual table.
表函数允许您对非实际表（不是实际上的表）中的数据有效地使用关系操作和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版本中更新和增强，而快照接口将不再更新。
These table functions take an XML document as input, and then output one column for each metric that is described in the DB2MonCommon.xsd file.
这些表函数采用XML文档作为输入，然后为DB 2 MonCommon. xsd文件中描述的每个指标输出一列。
Our table functions have been changing quite a bit lately, so I want to make sure our mapping files are updated when these changes are made.
我们的表函数最近改变很多，所以我想确保我们的映射文件更新时这些变化。
The new table functions are created after the procedure executes. To list the output columns for the table functions, execute the following statements
在执行该过程后创建新的表函数。
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表(这正是我们将其称作表函数的原因)。
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 （ 数据更改操作）放入到关联连接的内表中。
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文件中的监控器元素。
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查询、连接操作和分组等。
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 definitions of the two times-table functions are remarkably close, but the new version is considerably more useful (as you can see from the three invocations in Listing 3).
两个乘法表函数的定义非常相近，但清单3中的函数有用得多(通过清单3中的3次调用即可看出这一点)。
Table 1 shows some examples of these functions.
表1展示了这些函数的一些示例。
Table 3 summarizes some of the history editing functions available.
表3总结了一些可用的历史编辑功能。
The symbol table stores the details of all the symbols (functions) in the binary.
符号表存储了二进制文件中所有符号(函数)的细节。
These include Enum support, Spatial data types, auto-compiled LINQ queries, Table-Valued functions, and stored procedures with multiple results.
这些特性包括枚举支持、空间数据类型、自动编译LINQ查询、表值函数和多结果存储过程。
For step 2, I update the header files to make room for the new functions in the system call table.
对于步骤2来说，我对头文件进行了更新：在系统调用表中为这几个新函数安排空间。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIESSQLDATA的联邦过程。
Take a look at the properties of loops and see how they compare with those of recursive functions in Table 1.
在表1中了解循环的特性，看它们可以如何与递归函数的特性相对比。
You can reference a created temporary table in SQL functions, triggers, indexes, and views.
您可以在sql函数、触发器、索引和视图中引用已创建的临时表。
The full list of these built-in functions appears in Table 1.
这些内置函数的完整列表如表1所示。
应用推荐