Informix Guide to SQL: Tutorial
Chapter 7: Programming for a Multiuser Environment
Home
Contents
Index
Master Index
New Book
Controlling Data Modification with Access Modes
Universal Server supports access modes. Access modes affect read and write concurrency for rows within transactions and are set with the
SET TRANSACTION
statement. You can use access modes to control data modification among shared files.
Transactions are read-write by default. If you specify that a transaction is read-only, that transaction cannot perform the following tasks:
Insert, delete, or update table rows
Enable or disable constraints, triggers, or indexes
Create, alter, or drop any database object such as schemas, tables, temporary tables, indexes, or stored procedures
Grant or revoke privileges
Update statistics
Rename columns or tables
Read-only access mode prohibits updates.
You can execute stored procedures in a read-only transaction as long as the procedure does not try to perform any restricted statements.
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.