相反,虽然IDSSPL也支持类似的游标循环语句,但是不允许显式地声明、打开或关闭游标。
In contrast, IDS SPL supports a similar cursor looping statement but does not allow cursors to be explicitly declared, opened, or closed.
本文将从在ij工具内显式使用SQL游标开始讨论这两种方法。
This article discusses both methods, beginning with the explicit use of SQL cursors within the ij tool.
另一种方法是在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.
因为可以在运行数据库应用程序代码的JVM之外管理连接或数据库游标这样的资源,所以应用程序必须显式地关闭这些资源。
Because these resources, like the connection or any database cursors, can be managed outside the JVM running your database application code, your application must close them explicitly.
可持有结果集允许应用程序在隐式或显式提交之后一直将游标打开着。
A holdable result set permits an application to keep the cursor open after implicit or explicit commits.
可持有结果集允许应用程序在隐式或显式提交之后一直将游标打开着。
A holdable result set permits an application to keep the cursor open after implicit or explicit commits.
应用推荐