A point to note here is that if this approach is followed, the calls to the original UDF will have to be modified so that they now execute the stored procedure, and supply an extra OUT parameter.
这里要注意一点:如果采用这种方法,就必须修改对原udf的调用,改为执行存储过程并提供一个额外的OUT参数。
Typically, the UDF is used in the select list of a SQL query.
通常,这个UDF被用在SQL查询的select列表中。
Please note that this function utilizes BIT_OR UDF we wrote to operate on bit-like data type parameters.
注意,该函数使用了我们编写的BIT _ ORUDF对类似于位数据类型的参数进行运算。
Creating an external UDF should be used as a last resort.
创建外部UDF应该作为最后的手段。
The first option that you should try is to create it as an SQL UDF in DB2 by modifying the code.
应该首先尝试通过修改代码创建DB2 内部的SQLUDF。
The singleton provides us with the means to store another object that is used for the aggregation done in each UDF in the SQL statement.
单件为我们提供了一种可以将SQL语句中每一个UDF 进行聚集计算时需要的数据存储在另外的对象当中的方式。
The next UDF performs EXLUSIVE OR operation between two given integer values as translated to binary expressions
下一个UDF在给定的两个整数值之间执行EXLUSIVEOR运算,这两个值已经被转换成二进制形式
The DB2 SOAP UDF program uses these input parameters to launch a SOAP/HTTP request on behalf of the SQL client.
DB2SOAPUDF程序使用这些输入参数代表SQL客户机发出一个SOAP/HTTP请求。
Listing 14 is an example of a UDF that you can create to emulate MySQL's non-standard but commonly used NOW function.
清单14这是一个UDF示例,您可以用它来模拟MySQL的非标準化但经常被使用的NOW函数。
The new table UDF and view for compression information
用于压缩信息的新的表UDF和视图
When a UDF receives a ROW as argument, it can find out the number of columns that are defined, their names, their types and their content.
当一个UDF接收一个ROW参数时,它可以查明已定义的列数、列名、列类型、以及它们的内容。
The getAggregateResult UDF (set in italics) needs to decode the binary string and access the correct aggregation object.
getAggregateResultUDF(设置为斜体)需要对二进制串解码,然后访问正确的聚集对象。
Convert the UDF to a stored procedure.
把udf转换为存储过程。
To resolve the problem, run UDF in an unfenced mode or reduce database Shared memory set to no more than 5 segments.
要解决这个问题,可以在unfenced模式下运行udf,或者将数据库共享内存减少至不多于5个段。
The quality of the UDF and procedure migrations depend on the complexity of the source code.
UDF和过程的迁移质量依赖于源代码的复杂性。
File name: the name of the file used by the UDF for writing the script.
文件名:由udf用于编写脚本的文件的名称。
Listing 1 shows a simple UDF for handling cases where baseline data for an object does not exist, or where counter rollover has occurred (an unlikely scenario, but it is handled).
清单1给出一个简单的UDF,它处理对象的基线数据不存在或者发生计数器翻转的情况(这种情况不太可能出现,但是能够处理)。