SYS(1104) - Purge Memory Cache
Purges memory cached by programs and data, and clears and refreshes buffers for open tables.
SYS(1104 [, cAlias | nWorkArea])
Parameters
cAlias
Specifies the alias of a specific table or cursor for which cached memory is purged.nWorkArea
Specifies the work area of a specific table or cursor for which cached memory is purged.
Return Value
Character. SYS(1104) returns the number of bytes that could not be purged. SYS(1104) returns "0" if all memory is purged.
Remarks
You can improve performance by calling SYS(1104) after executing commands that make extensive use of memory buffers. This function also clears internal buffers for open tables, forcing the tables to be refreshed, which is useful with large tables and in multiuser environments.
Note
The use of SYS(1104) will slow performance in applications that have a large number of buffered tables open.
Include the optional cAlias or nWorkArea parameter to purge the memory cache for a specific table or cursor. This can be useful in multiuser scenarios that use the INDEXSEEK( ) Function to search indexed tables.