应用程序1再次打开游标。
在SQL过程中打开游标。
在执行部分打开游标 。
选择“创建静态游标”后，直到关闭并重新打开游标时才检测到更改。
When Create Static Cursor is chosen, the changes are not detected until the cursor is closed and reopened.
注意，对于游标声明，该值为打开游标的次数，不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
与消耗时间不同，对于声明游标的语句，CPU时间是打开游标、所有读取操作和关闭游标的时间总和。
Unlike elapsed time, in case of a declare cursor statement the CPU time is the sum of open, all fetched and close.
另一种方法是在ROLLBACK之后再次显式地打开游标，然后在ROLLBACK时把游标指针跳到读取的记录。
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.
ALTERTABLE等一些操作要求不打开游标，而CREATEINDEXONLINE等其它操作则允许表上的游标。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
做这么多工作仅仅是为了打开一个游标！
相反，虽然IDSSPL也支持类似的游标循环语句，但是不允许显式地声明、打开或关闭游标。
In contrast, IDS SPL supports a similar cursor looping statement but does not allow cursors to be explicitly declared, opened, or closed.
然后，DB2打开从过程中返回的游标，并处理分配给结果集的定位器。
Then DB2 opens the cursor returns from the procedure and processes the locator allocation to the result set.
默认情况下，AUTOCOMMIT处于启用状态，并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
在前面的示例中，两个用户交互之间将保持数据库游标打开，从而防止其他用户访问被锁定的数据段。
The previous example held the database cursor open between user interactions, preventing other users from accessing database segments that are locked.
这两种类型的不同之处是：它们在游标打开时对底层数据的变化是否敏感。
These two types differ in whether they're sensitive to changes made to the underlying data while the cursor is open.
打开将被返回的游标。
对于OLTP应用程序，所需的排序和临时空间会比较少，一次只打开少数并发游标。
For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time.
使游标对客户机应用程序保持打开状态(不要关闭它)。
Keep the cursor open for the client application (do not close it).
Oracle游标可以被声明、打开、取数据和关闭。
Oracle cursors can be declared, opened, fetched from, and closed.
如果Oracle数据库是源数据库，要确保设置大约10000个打开的游标。
Make sure your have around 10000 open cursors setting for the Oracle database if that is the source.
对于游标，这就是打开和关闭游标之间所经过的时间。
For a cursor this is the elapsed time between open and close.
可持有结果集允许应用程序在隐式或显式提交之后一直将游标打开着。
A holdable result set permits an application to keep the cursor open after implicit or explicit commits.
敏感游标将提供底层数据的一个动态视图，而不敏感游标通常对游标打开时数据库的变化不敏感。
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.
不可重复的读取：A 1中重新打开的游标检索a 2对符合资格的行的更新。
Non-repeatable reads: The reopened cursor in A1 retrieves updates of A2 on qualifying rows.
因此，DB 2需要dam结果集，以确保当游标被打开时整个查询已经完成。
So DB2 needs to dam the result set to ensure that the whole query is finished when the cursor is opened.
在你定义好一个游标后，下一步就是打开该游标。
Once you've declared your cursor, the next step is to open the cursor.
在你定义好一个游标后，下一步就是打开该游标。
Once you've declared your cursor, the next step is to open the cursor.
应用推荐