什么是多行获取?
If DB2 does not need to sort, then all of the work for finding a qualified row (or rows with multi-row FETCH) will be done at each FETCH.
如果DB 2不需要排序,那么所有寻找一个符合条件的行(或者有多行FETCH的行)的工作在每个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驱动程序仅允许对存储过程执行单行获取。
The default value for this property is true, which means the driver will always try to use multi-row fetch (MRF) for scrollable cursors if the server supports it.
该属性的默认值是true,这意味着在服务器支持的情况下,驱动程序将尝试对可滚动游标使用多行获取(MRF)。
In many cases, a separate disk access must be made to fetch the page for each row located through an index.
大多数情况下,对于通过索引定位的每一行,都必须进行单独的磁盘访问来读取该页。
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,直到使用了来自游标的所有行并将每一行存储在阵列的一个元素中。
Given a matching index, a single index fetch will pin down the row to be retrieved.
给定一个匹配的索引,通过一个单独的取索引操作就可以得到要检索的行。
Next, fetch values from the result set row and set the values in the input form fields.
接下来,从结果集行中取值,设置输入表单字段中的值。
It allows applications to specify the starting row of the fetch and the number of rows to be fetched from the database.
它允许应用程序指定从数据库中所取的起始行,以及所取的行数。
For each row ID, the FETCH operator reads the corresponding row from the table.
对于每一个行id,fetch操作符将读取表中相应的行。
Normally, there is a loop that continues to fetch each row until the end of the data is reached.
通常用一个循环连续获取每一行,直到到达数据的末尾。
Within the child thread, open a new connection to DB2 and fetch a row from the lock table for the requested resource ID.
在子线程中,打开新的DB 2连接,在锁表中获取具有所请求的资源ID的一行。
In essence, the OPEN positions into the index and the FETCH first will retrieve the first row based on the RRN provided by the index.
本质上,OPEN定位到索引中,FETCHFIRST将基于索引提供的rrn检索第一行。
After the FETCH, the program does "before and after" checking to see if anything on the row was changed by a different user while our user was staring at the screen display.
FETCH之后,程序进行“前后”检查,来查看在进行屏幕显示时,是否有不同用户对该行做了改动。
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 结束。
It can only fetch one row at a time from the web service response.
它每次仅能从Web服务响应获取一行。
In the normal operation the web service pack will only fetch a single row as output.
在正常的操作中,WebServicePack将仅获取一个行作为输出。
Thus the UPDATE fails to find the specified row. A message "SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
因此UPDATE无法找到指定的行,返回消息 “SQL0100W NorowwasfoundforFETCH, UPDATEorDELETE; ortheresultof aqueryisan empty table.
In the second set of stored procedures, strings were used in place of arrays, and cursors were heavily used to fetch rows from multi-row result sets.
在第二组存储过程中,使用字符串替代了阵列,且大量使用光标以便从多行结果集合中提取行。
With PEAR installed, the script can query the current messages, fetch each row, and output the user name and the comment text.
PEAR安装后,脚本可以查询当前的消息,检索每一行,输出用户名和消息文本。
The row ID scan (RIDSCN) operator then scans these row IDs, triggers row prefetching, and passes the row IDs to the fetch operator.
然后行id扫描(RIDSCN)操作符将扫描这些行,触发行预取,并将行id传递到fetch操作符。
Fetch just one row from that result set using odbc_fetch_row , which takes in the result set as a parameter.
使用odbc_fetch_row仅从结果集中提取一行结果,该函数接受作为参数的结果集。
When results of a query are sent back to a requesting application, they can be sent a-row-at-a-time every time a requesting application issues a FETCH request.
在将查询的结果发送回发出请求的应用程序之后,每当应用程序发出FETCH请求时,可以将结果逐行返回。
The fetch() function returns TRUE if the requested row exists and FALSE if the requested row does not exist.
如果被请求的行存在,则 fetch()函数返回TRUE,如果被请求的行不存在,则返回FALSE。
If fetch returns FALSE, the result set is empty, thus a catalog table row for the catalog id value is not defined in the database table.
如果fetch返回FALSE,则结果集为空,表明数据库表中还没有为catalogid值定义一个catalog表行。
The fetch function sets the result set pointer to the next row.
fetch函数将结果集指针指向下一行。
Listing 19 lists the plan showing the efficient use (FETCH (8)) of ORDER BY and FETCH FIRST 1 ROW ONLY discussed above.
清单19列出的计划展示了使用前面讨论的ORDER BY的(FETCH(8))和FETCHFIRST1ROWONLY的效率。
With Committed read isolation, it will give this error: 244: Could not do a physical-order read to fetch next row.
如果使用Committedread隔离级别,则会发生以下错误:244:couldnotdoaphysical - orderreadto fetch next row。
Therefore, the Catalog Id value added in the input form is not valid. If the fetch() method returns a row, set the innerHTML of the validationMessage div to "Catalog Id is not Valid"
因此,输入表单中添加的CatalogId值是无效的。
Does the "Fetch user info" stage mean that we take the user info from the site which is logged in, and create a new user (row) automatically in the other site?
“抓取用户信息”阶段是指我们从已登录的网站获取用户信息,并在其他网站自动创建新用户(行)?
应用推荐