Lock Number Record For Free

To lock or unlock a record: In the footprint tab, select a footprint record. From the actions menu, select Lock. Note Users who don't have the Modify All access to the required objects can't see the Lock action in the actions menu.

In the Access Options dialog box, click Advanced, and then select the option you want under Default record locking. Data in a form, report, or query from an Open Database Connectivity (ODBC) database is treated as if the No Locks setting were chosen, regardless of the RecordLocks property setting.

File locking and record locking are really the same thing, except that file locking blocks access to the whole file, while record locking blocks access to only a specified segment of the file.

Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results. The classic example is demonstrated by two bank clerks attempting to update the same bank account for two different transactions.

Record locks within RLS are owned by a named UOW within a named CICS region. The lock owner name is the APPLID of the CICS region, plus the UOW ID. For example, when CICS makes a request that can create a lock, CICS passes to VSAM the UOW ID.

Locking footprint records ensures that no data changes are made to the footprint or underlying energy use records, generated waste, or the procurement data entry records after the footprint is completed and finalized. Lock records that you don't want to be recalculated manually or by a system process.

The locking level determines the size of an object that is locked in a database. For example, many database systems let you lock an entire table, as well as individual records. An intermediate level of locking, page-level locking, is also common.