You can determine how long R:BASE continues to retry the last command until it receives a resource lock. By default, R:BASE waits four seconds and tries to access the resource throughout the wait period. If the table or database is still unavailable when the wait period expires, a message is displayed. You can either retry the command, or roll back the transaction.

To change the wait period, specify a value in seconds for the WAIT setting; for example, enter:

SET WAIT 10

You can also specify how often R:BASE retries the command within the SET WAIT period. The maximum setting for the INTERVAL command (in tenths of a second) is nine; the default is five.

For example, to specify an interval of nine tenths of a second, enter:

SET INTERVAL 9

Transaction Processing Topics

Using Transaction Processing

Locking Table Access and Resource Waiting

Row Locks and Transaction Processing

Automatic Table and Database Locks

Setting Exclusive Table Locks

Displaying Transaction Processing Locks

Recovering from Transaction Processing Errors

See also

SET INTERVAL Command

SET WAIT Command