OpenEdge Advanced Business Language: Difference between revisions

Revision as of 17:19, 5 September 2024

Revision as of 15:36, 14 November 2024

Line 103:

(Some assumptions have been made about indexing, locking and transaction scoping in order to keep this example simple.)

Data access in the ABL is record based as opposed to result-set based processing in traditional SQL-based languages. In SQL operations work on a set of records, in the ABL, the operation is applied to a record at a time - much like using a cursor in SQL but much more efficient. Record-based processing provides a clean and reliable locking mechanism which allows the developer to EXECUTIVE-LOCK, SHARE-LOCK or NO-LOCK a record when accessed by the application.

==Application areas==