Locking shared data

By definition, all database files can be used by many users at the same time. However, some operations can lock files, members, or records to prevent them from being shared across jobs.

When files, members, or records are locked, no other jobs can read the same data for update operations, which keeps another job from unintentionally deleting the first job's update.

You can lock a row by using the SQL LOCK TABLE statement. In addition to rows, you can lock files, members, and data records. You can display locked records using the Display Record Locks (DSPRCDLCK) command.