Exec

Table of Contents



EXEC (or EXECUTE) runs one of the built-in System Procedures. Parameters are passed in parentheses; the parentheses can be omitted when there are no parameters. Procedure names are not case-sensitive.

User-defined procedures

User-defined stored procedures are not currently available, see Alter Procedure. EXEC with a name that is not a system procedure fails with "Procedure not found".


round-pushpin Runs a procedure without parameters.
EXEC ShowProcesses

round-pushpin Runs a procedure with a parameter.
EXEC ShowLocks(1)




SQL :: ShowSystemFunctions
Lists the built-in system procedures with their parameters and descriptions.
SQL :: ShowThreadPools
Shows the threads of the engine's thread pools (lookup, indexing, intersection and materialization) and their processor usage.
SQL :: ShowTransactions
Shows every active transaction, optionally for a single process.
SQL :: ShowVersion
Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.
SQL :: ShowWaitingLocks
Shows the processes that are currently blocked waiting for a lock, optionally for a single process.
SQL :: Sleep
Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.