If the cursor is closed using the close statement before the return of the SQL procedure, the cursor result set will not be returned to the caller or client application.
如果在返回SQL过程之前使用close语句关闭游标，那么游标结果集就不会返回到调用者或客户机应用程序。
A holdable result set permits an application to keep the cursor open after implicit or explicit commits.
可持有结果集允许应用程序在隐式或显式提交之后一直将游标打开着。
I explained that DB2 does not automatically build a result set of all qualified rows at OPEN CURSOR.
我解释过DB 2不能在OPEN CURSOR中为所有符合条件的行自动生成一个结果集。
If you have a long-running OPEN CURSOR, it is not because DB2 is building a result set. It is most likely because DB2 is doing a data sort at OPEN (usually to satisfy a common ORDER BY).
如果您有一个长期运行的OPENCURSOR，并不是因为DB 2正在构建一个结果集，最有可能是因为DB 2正在OPEN(通常满足一个常见orderBY)上进行数据排序。
The TSQLConnection component is equipped with an ExecuteDirect method to execute an SQL command that doesn't return a result set (also called cursor).
TSQLConnection组件有一个 ExecuteDirect方法，该方法可以执行不返回结果集合的SQL命令（也称为指针）。
It's worth noting that you do not perform the distinct function on a cursor or result set as you do other query functions, but you perform it directly on the collection.
值得注意的是，您在执行其他查询函数时不能在指针和结果集上执行distinct函数，而应直接在集合上执行。
DB2 Connect's optimized network communications infrastructure include the ability to minimize network flows related to cursor (result set) management.
DB 2Connect经过优化的网络通信基础设施具有减少与游标(结果集)管理相关的网络流的能力。
Then DB2 opens the cursor returns from the procedure and processes the locator allocation to the result set.
然后，DB2打开从过程中返回的游标，并处理分配给结果集的定位器。
One cursor is required per result set that is to be returned.
每个将要返回的结果集都需要一个游标。
This means that subsequent SQL OPEN and CLOSE operations will merely reposition the cursor to the first row of the result set.
这意味着后续SQLOPEN和CLOSE操作只是将游标重新定位到结果集的第一行。
In fact, the dimension cursor is similar to an SQL result set with some additional functionality.
实际上，维游标类似于SQL结果集，只是多了一些附加功能。
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循环的每一次迭代，取回的下一行就是结果集。
A scrollable result set allows the cursor to be moved to any row in the result set.
可滚动结果集允许游标移动到结果集中的任意行。
The value of SQLSUCCESS is often used to determine when the cursor has reached the end of the result set, as shown in Listing 15.
SQLSUCCESS的值通常用来确定游标何时达到结果集的末尾，如清单15所示。
The find() function actually returns a cursor to the result set of the query, in this case, retrieve all documents.
find()函数实际上向查询结果集返回了一个指针，在本例中是检索所有文件。
So DB2 needs to dam the result set to ensure that the whole query is finished when the cursor is opened.
因此，DB 2需要dam结果集，以确保当游标被打开时整个查询已经完成。
Static cursors use a work table to store the complete result set of the cursor.
静态游标使用工作表来存储游标的完整结果集。
Static cursors use a work table to store the complete result set of the cursor.
静态游标使用工作表来存储游标的完整结果集。
应用推荐