The OPEN CURSOR statement is executed as part of the FETCH process.
OPEN cursor语句作为FETCH过程的一部分执行。
I do not mind when folks say that DB2, when sorting, builds a SORTOUT file at OPEN CURSOR.
我不介意员工说DB2在排序的时候在OPEN CURSOR上建立了一个SORTOUT文件。
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).
如果您有一个长期运行的OPEN CURSOR，并不是因为DB 2正在构建一个结果集，最有可能是因为DB 2正在OPEN(通常满足一个常见orderBY)上进行数据排序。
For a cursor this is the elapsed time between open and close.
对于游标，这就是打开和关闭游标之间所经过的时间。
Unlike elapsed time, in case of a declare cursor statement the CPU time is the sum of open, all fetched and close.
与消耗时间不同，对于声明游标的语句，CPU时间是打开游标、所有读取操作和关闭游标的时间总和。
That was a lot of work, just to open a cursor!
做这么多工作仅仅是为了打开一个游标！
After the second execution of the OPEN within the same session or job, the SQL cursor will become reusable.
在同一个会话或作业中第二次执行open后，SQL游标将变得可重用。
Open the cursor in the SQL procedure.
在SQL过程中打开游标。
The previous example held the database cursor open between user interactions, preventing other users from accessing database segments that are locked.
在前面的示例中，两个用户交互之间将保持数据库游标打开，从而防止其他用户访问被锁定的数据段。
A holdable result set permits an application to keep the cursor open after implicit or explicit commits.
可持有结果集允许应用程序在隐式或显式提交之后一直将游标打开着。
These two types differ in whether they're sensitive to changes made to the underlying data while the cursor is open.
这两种类型的不同之处是：它们在游标打开时对底层数据的变化是否敏感。
Switch to the stored procedure editor ASSOC_PROC and pass the code between the cursor declaration and the cursor "OPEN" statement.
切换到存储过程编辑器 ASSOC_PROC 并传递进指针声明和指针 “OPEN”语句之间的那些代码。
Another approach is to explicitly open the cursor again after ROLLBACK and skip the cursor pointer till the record read at the time of ROLLBACK.
另一种方法是在ROLLBACK之后再次显式地打开游标，然后在ROLLBACK时把游标指针跳到读取的记录。
A sensitive cursor provides a dynamic view of the underlying data, whereas an insensitive cursor generally isn't sensitive to any changes made to the database while the cursor is open.
敏感游标将提供底层数据的一个动态视图，而不敏感游标通常对游标打开时数据库的变化不敏感。
This means that subsequent SQL OPEN and CLOSE operations will merely reposition the cursor to the first row of the result set.
这意味着后续SQLOPEN和CLOSE操作只是将游标重新定位到结果集的第一行。
This also explains the use of the PREPARE, DECLARE, OPEN and CLOSE SQL cursor statements.
这也解释了使用PREPARE、DECLARE、OPEN和CLOSEsql游标语句的原因。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
ALTERTABLE等一些操作要求不打开游标，而CREATEINDEXONLINE等其它操作则允许表上的游标。
Also, when you type an open parenthesis or double quote, Eclipse will provide its partner automatically and place the cursor inside the pair.
当您键入开括号或双引号时，Eclipse会自动提供配对的符号，并将光标置于符号对之内。
To do this, make sure the cursor is in the new cell and open the Table property box.
要进行此操作，请确保指针位于新的单元格中，并打开表属性框。
Keep the cursor open for the client application (do not close it).
使游标对客户机应用程序保持打开状态(不要关闭它)。
Once you've declared your cursor, the next step is to open the cursor.
在你定义好一个游标后，下一步就是打开该游标。
Remember the "cursor position" on close and resume on open.
退出笔记时记住光标位置。打开时恢复该位置。
OPEN the cursor in the Execution Section.
在执行部分打开游标 。
Open the target project and select the code event element by placing the cursor on the event object.
打开目标项目并通过将光标放在事件对象上来选择代码事件元素。
Open the target project and select the code event element by placing the cursor on the event object.
打开目标项目并通过将光标放在事件对象上来选择代码事件元素。
应用推荐