Ricky

链接

RSS

RSS Link
DB2中获取多行游标的使用
DB2密码过期修改密码

DB2中的ROWID和游标

Ricky posted @ 2014年5月09日 10:18 in Other , 1116 阅读

DB2的RID对于分区表同样是唯一值:

Declare c1 cursor with hold for
Select
Pk,
Value, RID(t)
Into
:Va,
:Vb
 
from tbname t
Order by Pk
For fetch only
 
fetch pk,value, my-rid
 
Update:
Set
Value = :Vb
Where
RID(t) = my-rid
If the row is not the same row as fetched it will give you a +100
 

登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter