提供用于汇总所有行而不是分组行集的步骤。
Provides steps for summarizing all rows rather than for a set of grouped rows.
当已经用完一个页面时,就必须读入下一行集的页。
When one page is exhausted, the page for the next set of rows must be read in.
将重新准备fetch语句,并且不包含行集定位。
The fetch statement will be re-prepared without rowset positioning.
首先查询数据库以获取与所选种类匹配的所有货品的行集。
First we query the database to get a row set of all the items that match the selected category.
对于行集游标,JDBC1定位更新语法必须知道行集的存在。
For rowset cursors, the JDBC 1 positioned update syntax needs be aware of the rowset.
如果没有启用MRF,准备fetch语句时将不包含行集定位。
If MRF is not enabled, FETCH statements are prepared without rowset positioning.
提供程序不支持架构行集,因此无法将它的元数据扫描到知识库中。
The provider does not support Schema Rowsets, so its metadata cannot be scanned into the Repository.
这是因为T2zos需要行集支持来获得默认的false或unset。
This is because T2zos requires the rowset support to have a default of false or unset.
因此,连接行集数是两个行集的行集数的乘积,被选择的谓词连接的乘积。
Therefore, the join cardinality is the product of the cardinalities of two row sets, multiplied by the selectivity of the join predicate.
可以把内联自定义函数想象成视图,它接受参数,而且可用于JOIN和其他行集操作。
Inline UDF's can be thought of as views that take parameters and can be used in JOINs and other Rowset operations.
该算法可通过查看映射到同一行集的项中涉及的maxOccurs属性和模型组来确定关系。
The algorithm can determine the relationship by looking at the maxOccurs property and the model groups involved in the items mapped to the same rowSet.
如图1所示,通过获取多个行,应用程序减少了SQL调用,并且可以使用一个fetch语句获取行集。
As illustrated in Figure 1, by fetching multiple rows, your applications reduce the number of SQL calls and can fetch a rowset using a single fetch statement.
t2zos不知道从存储过程返回的游标是不是一个行集,因此t2zos驱动程序仅允许对存储过程执行单行获取。
T2zos does not know if the cursor returned from a stored procedure is rowset or not, thus the t2zos driver allows only single row fetch for a stored procedure.
如果有附加的过滤器需要在表访问步骤之后应用于数据,在被包括在,自那步起的最终结果集之前,行集将穿过过滤器。
If there are additional filters that need to be applied to the data after the table access step, the rows will pass through that filter before being included in the final result set from that step.
数据分区也称为范围(当前DB 2只支持范围分区方案),一个数据分区包含一个行子集,这些行存储在与表中其他行集不同的地方。
A data partition, also referred to as a range (currently DB2 supports only a range partitioning scheme), contains a subset of rows that are stored separately from other sets of rows in the table.
而且传统的数据库驱动技术,是以行集的方式而不是以对象的方式处理数据,需要将对象模型进行转换,实现对象数据到数据库的持久化存储。
What is more, the traditional database driver handles data by collection of rows which requires converting object data to relational one for persistent storage.
结果集是一个数组,该数组由0个或多个与数据库查询相匹配的行组成;结果集标识符只是一个值,您可以将该值传递给其它函数,以使它们能够使用结果集中的行。
A result set is an array consisting of 0 or more rows that match a database query; a result set identifier is simply a value that you pass to other functions to work with the rows in the result set.
通过枚举器检索的每个值都应与结果集的一行对应。
Each value retrieved via the enumerator should correspond with one row of the resultset.
存储过程可以返回零个或更多的结果集,每个结果集由一组行组成。
Stored procedures can return zero or more result sets, each consisting of a set of rows.
在下面的清单6中,故障处理程序通过相应的一组元素(第36行)定义了它试图处理的故障集。
The fault handler in Listing 6 below defines the set of faults it attempts to handle via a corresponding set of elements (line 36).
行模式很适合那些复制或压缩大型文件集的系统管理脚本。
Line mode is ideal for systems administration scripts that copy or compress large collections of files.
因为这都是些标量函数,所以将为结果集的每一行创建XML数据类型的结果。
Since these are scalars functions, for each line of the result set, a result of the XML data type is created.
在查找一组特定的行的时候,这个特性非常有用,而且比通过滚动整个结果集寻找所需的行要快得多,也简单得多。
This feature is useful when looking for a particular set of rows, and is much faster and simpler than finding the desired rows by scrolling through the entire result set.
我解释过DB 2不能在OPENCURSOR中为所有符合条件的行自动生成一个结果集。
I explained that DB2 does not automatically build a result set of all qualified rows at OPEN CURSOR.
是否每个人都认同可重用资产的单一行为集,或者每个人都采用自己的自定义版本,实际上完全不能进行重用?
Can everyone really agree on a single set of behavior for a reusable asset, or will everyone have their own customized version which isn't really being reused after all?
接下来,从结果集行中取值,设置输入表单字段中的值。
Next, fetch values from the result set row and set the values in the input form fields.
测试的第二个查询使用了一条将返回包含数千行数据的结果集的sql语句。
The second query evaluated USES an SQL statement that returns thousands of result set rows.
这意味着后续SQLOPEN和CLOSE操作只是将游标重新定位到结果集的第一行。
This means that subsequent SQL OPEN and CLOSE operations will merely reposition the cursor to the first row of the result set.
在执行for语句时,游标被隐式声明,这样对于FOR循环的每一次迭代,取回的下一行就是结果集。
When a for statement is executed, a cursor is implicitly declared such that for each iteration of the for loop, the next row is the result set if fetched.
在执行for语句时,游标被隐式声明,这样对于FOR循环的每一次迭代,取回的下一行就是结果集。
When a for statement is executed, a cursor is implicitly declared such that for each iteration of the for loop, the next row is the result set if fetched.
应用推荐