Using Your Model › Locking Objects › Implicit *EXCL File Locks

Implicit *EXCL File Locks

Implicit locks are set automatically when a *DSNR performs an action that updates a relation or has the intent of updating a file. Operations that set *EXCL locks include adding, changing, or deleting a relation, and adding a virtual entry.

Once a file is updated, only a *DSNR can use the file until the file is expanded or the model is synchronized. Depending on the type of update, other files can also be locked.

• Adding a relation to a file sets an *EXCL lock on the current file only.
• If you delete or change a non-key relation on a file, sets an *EXCL lock on the file and any files having entries derived from the relation; for example, virtual entries.
• If you delete or change a key relation for a file,CA 2E sets *EXCL locks on all files that use the file. For example, if you delete the first relation shown below,CA 2E sets *EXCL locks on the Order, Order detail, Order detail line, and Invoice files.