SET SHARE

Purpose

Determines whether or not table and index files are opened shareable

Syntax

SET SHARE ON | OFF | (<expL>)

See Also

INDEX, PACK, REINDEX, SET EXCLUSIVE, USE, ZAP

Description

If SET SHARE is OFF when a table and its associated index files are opened, then the table and index files cannot be by another user until they are closed. If SET SHARE is ON when a table and its associated index files are opened, then the table and index files are shareable by multiple users.

File and record locking to control concurrent updates to the table and index files is automatically enforced if SHARE was ON when the table was opened.

Example

set share on
open database southwind
use customers