当您处于游标定位模式时,用户可以切换,或者定位游标到输入区域的任何一个字符之上。
When in cursor-positioning mode, the user can tab to, or position the cursor on, any character in the input field.
在游标定位在行中时,锁定这个被应用程序的某个事务访问的任何一行。
Locks any row accessed by a transaction of an application while the cursor is positioned on the row.
初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
CS:在游标定位在任何一行中时,锁定这个被应用程序的某个事务访问的行。
CS: Locks any row accessed by a transaction of an application while the cursor is positioned on the row.
为了切换至游标定位模式,用户可以激活链接,由星号(*)标示,接下来就是输入区域。
To switch to cursor positioning mode, the user activates the link, designated by the asterisk (*), following the input field.
JDBCAPI的灵活性还允许您创建一个可以通过编程的方法来使用的游标,用于通过发出相应的SQL命令执行定位更新和删除。
The flexibility of the JDBC API also permits you to create a cursor that you can use programmatically to perform positioned updates and deletes by issuing the appropriate SQL commands.
对于行集游标,JDBC1定位更新语法必须知道行集的存在。
For rowset cursors, the JDBC 1 positioned update syntax needs be aware of the rowset.
数据行只是在游标定位它们时才锁定,一旦获取下一行之后,锁将被解除。
Rows are only locked at the point in time that a cursor is positioned on them; once the next row is fetched, the lock is released.
接下来,使用BEFOREFIRST命令把游标定位到第一行之前,这样才可以调用NEXT命令来访问游标中的第一行。
NEXT you use the before first command to position the cursor before the first row so that you can call the NEXT command to access the first row in the cursor.
图17显示了游标定位在MYIDBAD用户ID的字母b上。
Figure 17 shows the cursor positioned at the letter B in the MYIDBAD user ID.
另外,您可以使用设置,Enablecurs orpositioningoptiononinputfields,来允许用户从数据输入模式切换至游标定位模式。
In addition, you can use the setting, Enable cursor positioning option on input fields, to allow the user to switch from data input mode to cursor positioning mode for input fields.
上述这些游标都很有用,但是,直接操纵游标的实际价值在于在特定位置更新数据库的能力。
All of this is fine, but the real value of directly manipulating a cursor is the ability to update the database at a particular position.
然后,DB2打开从过程中返回的游标,并处理分配给结果集的定位器。
Then DB2 opens the cursor returns from the procedure and processes the locator allocation to the result set.
这意味着后续SQLOPEN和CLOSE操作只是将游标重新定位到结果集的第一行。
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 means that subsequent SQL OPEN and CLOSE operations will merely reposition the cursor to the first row of the result set.
应用推荐