Difference between revisions of "SET SHARE"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Determines whether or not table and index files are opened shareable ==Syntax== SET SHARE ON | OFF | (<expL>) ==See Also== INDEX, PACK, REINDEX, SE...") |
Yvonne.milne (Talk | contribs) |
||
Line 22: | Line 22: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
− | [[Category:Set_Commands| | + | [[Category:Set_Commands|SHARE]] |
[[Category:NoSQL Commands]] | [[Category:NoSQL Commands]] |
Latest revision as of 11:59, 14 June 2016
Contents
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