Informix Guide to SQL: Tutorial
Chapter 7: Programming for a Multiuser Environment
Home
Contents
Index
Master Index
New Book
Locking and Integrity
Unless controls are placed on the use of data, concurrency can lead to a variety of negative effects. Programs can read obsolete data, or modifications can be lost even though they were apparently completed.
To prevent errors of this kind, the database server imposes a system of
locks
. A lock is a claim, or reservation, that a program can place on a piece of data. The database server guarantees that, as long as the data is locked, no other program can modify it. When another program requests the data, the database server either makes the program wait or turns it back with an error.
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.