How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
Record lock, Embedded SQL, SQLRPGLE
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs? Question
Record lock, Embedded SQL, SQLRPGLE
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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
Browse more Questions and Answers on AS/400 and Database.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
