Unanswered: SQL0511N The FOR UPDATE clause is not allowed because the table specified by the....
I am getting error
" com.ibm.db.DataException: A
database manager error occurred. : [IBM][CLI Driver][DB2/NT]
SQL0511N The FOR UPDATE clause is not allowed because the
table specified by the cursor cannot be modified.
on executing query
select m.msgtyp, m.msg, m.msg_id, md.devcod from mtfmsg m
, mtfmsg_delv md
md.msg_id = m.msg_id and
md.rcvflg = 0 and
md.rcvdte is null and
(md.expdte is null or current timestamp < md.expdte) and
md.devcod = 'TEL02W'
order by md.insdte
for update of rcvdte
on UDB DB2 client. I think multiple table columns or joins with for update clause is not supported in DB2.Is there any alternate solution ? Please help me in resolving this problem