When the FETCH cursor statement fails and does not find another row to retrieve, the value of SQLSUCCESS is set to 0 and the WHILE LOOP ends.
当FETCH游标语句失败并且没有找到另一个要检索的行,SQLSUCCESS的值被设置为 0 并且WHILE LOOP 结束。
After the quantity check, the procedure tries to fetch next from the cursor, but if the rollback occurred, this causes an error because the rollback closed the cursor.
检查完数量后,过程将尝试从指针中获取下一个订单,但是如果发生了回滚,将会产生一个错误,因为回滚关闭了指针。
When it detects a potential update target, the federated system avoids using the block fetch feature in order to maintain the remote cursor position.
当检测到一个潜在的更新目标时,联邦系统避免使用块读取特性,以维护远程游标的位置。
ORACLE implicitly repeats the FETCH until all the rows from the cursor are consumed and stores each row in an element of the array.
ORACLE隐式重复FETCH,直到使用了来自游标的所有行并将每一行存储在阵列的一个元素中。
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.
t2zos不知道从存储过程返回的游标是不是一个行集,因此t2zos驱动程序仅允许对存储过程执行单行获取。
This means that a cursor which does not drive to EOF may show more rows in FETCH_COUNTS than were actually fetched using the fetch statement.
这意味着使用fetch语句时,未到达EOF的游标可能在FETCH_COUNTS中展示比实际读取更多的行数。
While you can change value during the life of the cursor, the change only affects the number of records in the cache after the next fetch from the data source.
虽然您可以在资料指标的存留期间变更值,但变更只会在下一次从资料来源撷取资料录之后,影响快取中的资料录数目。
The query used to retrieve rows when a fetch is issued against a cursor.
当对游标发出提取命令时,用于检索行的查询。
The query used to retrieve rows when a fetch is issued against a cursor.
当对游标发出提取命令时,用于检索行的查询。
应用推荐