The Multi-User Concurrency Control and Locking Table describes the automatic concurrency control and locks used in multi-user mode and the commands that initiate them. Operations that only view data or the database structure are not affected by concurrency control or locking.

The Accessing Tables and Databases Table shows what happens when different commands try to access a table or database already being used by another command. The columns represent the type of control or lock already placed on the table or database. Each row has a heading with the name of the control or lock needed by the command trying to gain access to a table or database.

Locks Topics

Using the SET ROWLOCKS Command to Lock Rows

Using the SET VERIFY Command to Verify Data Entry

Using SET LOCK to Set Exclusive Table Locks

Displaying Multi-User Locks

Clearing Buffers with the SET CLEAR Command

Other Multi-User Considerations

Multi-User Mode Topics

Introduction to Using R:BASE on a Network

Setting Up for Network Use

Sharing Network Resources

Setting the Multi-User Default

Concurrency Control

Resource Waiting

Schema Reading Mode with SET STATICDB