FOR update clause to obtain an update lock.
FORupdate子句来获取更新锁定。
The update clause will ensure that an update lock is held on the selected rows.
更新子句将确保更新锁定在被选择的行上。
When an attempt to update is made, the lock will be promoted to an update lock.
当尝试获取更新锁定时,该锁定将变为更新锁定。
As a result, the DB2 update lock for the row is released and this row is found by the next SQL select statement in Listing 2.
因此,会释放这一行的DB2更新锁,清单2中的下一个SQLselect语句会看到这一行。
The normal behaviour of a database access is to get a read lock on the queried data, which gets transformed into an update lock if data is updated.
数据库访问通常会对被查询的数据进行读锁定,在数据更新后会变成更新锁定。
If this row lock is protecting an uncommitted UPDATE or DELETE action, DB2 cannot process or ignore the row until the outcome of the change is known.
如果这个行锁在保护一个未提交的UPDATE或DELETE动作,那么DB 2不能处理或忽略该行,直到变化的结果已知。
When a table holds a Z lock, no concurrent application can read or update data in that table.
当表持有z锁时,任何并发应用程序都不能读取和更新该表中的数据。
This is usually the second worst performing strategy due to its cache lock requirement and the heavy "push" update policy for clustered caches.
这通常是性能倒数第二的策略,因为它要求有缓存锁,缓存集群中使用重量级的“推”更新策略。
In the first session, execute the UPDATE statement shown in Listing 16, which places an exclusive lock on the row with department number B01.
在第一个会话中,执行清单16中的update语句,它对部门号为B01的部门行设置独占锁。
When a table holds an IX lock, the lock owner and concurrent applications can read and update data in that table.
当表持有IX锁时,锁拥有者和并发应用程序可以读和更新该表中的数据。
For the example, it is not the SELECT statement that caused the problematic lock, but the UPDATE statement executed just before the SELECT statement in the same transaction.
例如,不是select语句造成产生问题的锁,但update语句恰好在同一事务中在select语句前执行。
Tables created by Informix default to page-level locking, so when two or more users attempt to update a row on the same page, at least one will get a lock error.
Informix创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
The APP Put operations are used to update the lock information of the place.
使用 APPPut操作更新该位置的锁定信息。
When you want to update address information, you must first call BAPI_EMPLOYEET_ENQUEUE to lock the HR record for this employee.
如果需要更新地址信息,首先必须调用BAPI_EMPLOYEET_ENQUEUE锁定该雇员的HR记录。
Before an RPG program updates a row accessed by a key it must perform a read operation to lock the row for update intent.
R PG程序更新通过键访问的行之前,必须执行一个读操作,以便锁定该行,进行更新。
Prior to DB2 9.7, the statement issued by AppB would hang because it would wait for the exclusive lock held by the update statement of AppA (the writer) to be released.
在DB 2 9.7之前,AppB发出的语句会被挂起,因为它要等待释放AppA (writer)的update语句持有的排他锁。
You can (and should) lock down the delete and update closures with the same four lines of code.
您可以(也应该)使用相同的四行代码锁定delete和update闭包。
When successful, a forced dismount allows exclusive volume access and a reliable boot code update even though the initial lock failed.
如果锁定成功,强制删除将启用独占卷访问权限和可靠的启动代码更新,即使初始锁定失败。
Specifying True causes the select for update extension to be used whenever the bean is loaded from the database and hold that lock for the duration of the transaction.
选择True会使只要从数据库加载bean,就会使用selectfor update扩展,并在事务持续过程中维持锁定。
Now let's start session 2 and have it update another row in the Orders table. Same situation – session acquires and holds X lock on the row with (ID = 2).
现在,我们开启会话2也更新订单表,不同的是更新的数据行为Id=2,同样的在数据行Id=2上也会申请排它锁至到更新事务的结束。
That's it – blocking occurs not because multiple sessions are trying to update the same data, but because of non-optimized query that needs to process/acquire lock on the data it does not really need.
所以阻塞的发生并不是因为同时有多个会议尝试去更新相同的数据,而是因为没有经过优化的查询申请了锁,但读取到的数据往往是不必要的数据。
When you use a recordset to update a record on the data source, your application can lock the record so no other user can update the record at the same time.
当您使用资料录集来更新资料来源上的资料录时,您的应用程序可锁定资料录,因此没有其他使用者可以在同时间内更新该资料录。
You may also attach a previously loaded object to a new Session with update() or lock() before accessing unitialized collections (or other proxies).
你也可以把先前装载的对象附加到一个新的Session去,需要在访问未初始化的集合类(或其他代理)前使用update() 或lock()。
You may also attach a previously loaded object to a new Session with update() or lock() before accessing unitialized collections (or other proxies).
你也可以把先前装载的对象附加到一个新的Session去,需要在访问未初始化的集合类(或其他代理)前使用update() 或lock()。
应用推荐