LOCKINFO()

From Recital Documentation Wiki
Revision as of 14:15, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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