Exec



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


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

round-pushpin Executes a user defined stored procedure passing it a parameter.
EXEC WordList:Word:CreateAndGetWord('Katzebase')




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