How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 18, 2008 6:32 AM
UPDATED:
May 19, 2008 3:05 PM
Answer Wiki:
Make the Select statement with the "For Update" clause, this way the record(s) selected will be locked until the Cursor releases it:
Declare MyCursor For
Select *
From MyFile
Where MyCondition
For Update
...
Close MyCursor
Regards,
Gerardo
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
