Oct 30 2013

Using Record Locking API’s [C BSFN]

VN:F [1.9.22_1171]
Rating: 4.0/5 (1 vote cast)
Record Locking Mechanism

Courtesy ZOSOMAZ

Record locking is a basic functionality of an RDBMS. This is how we do it within JDE in business functions.

The API’s used for the cause are

  1. JDB_FetchKeyedForUpdate
  2. JDB_SelectKeyedForUpdate
  3. JDB_FetchForUpdate
  4. JDB_UpdateCurrent

As this is very simple to use, given are the parameters with comments.

Download the following  files to view it in action.

Published under the license.

VN:F [1.9.22_1171]
Rating: 4.0/5 (1 vote cast)
Using Record Locking API's [C BSFN], 4.0 out of 5 based on 1 rating
(Visited 386 times, 1 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

Leave a Reply