Exec

Table of Contents

Overview
The EXEC directive is used to execute a stored procedure whther it be built-in or user created.

Example

Executes the built-in ShowCachePartitions procedure to show the memory cache partitions.

exec ShowCachePartitions

Executes a user defined stored procedure passing it a parameter.

EXEC WordList:Word:CreateAndGetWord('Katzebase')

CheckpointHealthCounters - Writes the health counters to disk.
ClearCacheAllocations - Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
ClearHealthCounters - Clears the health counters that are tracked by the engine.
ReleaseCacheAllocations - Releases unused memory from the internal memory cache back to the operating system.
ShowBlocks - Shows blocks associated with a process.
ShowBlockTree - Shows all blocked processesand their dependencies.
ShowCacheAllocations - Shows the cache allocation details.
ShowCachePartitions - Shows the memory allocations by memory cache partition.
ShowHealthCounters - Shows the health counters that are tracked by the engine.
ShowLocks - Shows all locks for all transactions.

<< First | < Previous | Next > | Last >>