How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
Home > IT Answers > AS/400 > How to explicitely Lock a record of a file in...
Lokanath
5 pts.
0
Q:
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?
ASKED: May 18 2008  6:32 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
GAC
300 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: May 19 2008  3:05 PM GMT by GAC   300 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0