Difference between revisions of "LOCKINFO()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 36: Line 36:
 
[[Category:Table Basics]]
 
[[Category:Table Basics]]
 
[[Category:Table Basics Functions]]
 
[[Category:Table Basics Functions]]
[[Category:Data Functions]]
 

Latest revision as of 14:15, 5 July 2011

Purpose

Function to return lock information about a specified file


Syntax

LOCKINFO(<expC>)


See Also

ISLOCKED(), LKSYS(), SET EXCLUSIVE


Description

The LOCKINFO() function returns lock information about the specified file named in <expC>, which can be a table or index file. If there are no locks active on the specified file or it does not exist, LOCKINFO() returns an empty string. If there are locks active on the file, LOCKINFO() returns a string with the following information about the lock(s):

  • name of user
  • id of process
  • tty connection
  • mode: shared / exclusive

Information is returned about one process, although more than one process may have locks on the file.

Example

? lockinfo("/opt/recital/data/southwind/example.dbf")
root(8053) /dev/pts/3 shared
? lockinfo("/opt/recital/data/southwind/example.dbx")
root(8053) /dev/pts/3 shared


Products

Recital Server, Recital