Difference between revisions of "SET EXCLUSIVE"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Determines whether or not table and index files are opened shareable | Determines whether or not table and index files are opened shareable | ||
| − | |||
==Syntax== | ==Syntax== | ||
SET EXCLUSIVE ON | OFF | (<expL>) | SET EXCLUSIVE ON | OFF | (<expL>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[INDEX | + | [[INDEX]], [[PACK]], [[REINDEX]], [[SET SHARE]], [[USE]], [[ZAP]] |
| − | + | ||
==Description== | ==Description== | ||
If SET EXCLUSIVE is ON 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 EXCLUSIVE is OFF when a table and its associated index files are opened, then the table and index files are shareable by multiple users. | If SET EXCLUSIVE is ON 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 EXCLUSIVE is OFF 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 EXCLUSIVE was OFF when the table was opened. | + | File and record locking to control concurrent updates to the table and index files is automatically enforced if EXCLUSIVE was OFF when the table was opened. |
| − | + | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
set exclusive off | set exclusive off | ||
| − | + | open database southwind | |
| − | + | use customers | |
| − | + | </code> | |
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|EXCLUSIVE]] | [[Category:Set_Commands|EXCLUSIVE]] | ||
| − | [[Category: | + | [[Category:NoSQL Commands]] |
| − | + | ||
Latest revision as of 11:58, 14 June 2016
Contents
Purpose
Determines whether or not table and index files are opened shareable
Syntax
SET EXCLUSIVE ON | OFF | (<expL>)
See Also
INDEX, PACK, REINDEX, SET SHARE, USE, ZAP
Description
If SET EXCLUSIVE is ON 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 EXCLUSIVE is OFF 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 EXCLUSIVE was OFF when the table was opened.
Example
set exclusive off open database southwind use customers
