statement cache nolimit argument: Control whether to insert qualified statements into the SQL statement cache (SQL administration API)

Use the statement cache nolimit argument with the admin() or task() function to control whether to insert statements into the SQL statement cache after its size is greater than the STMT_CACHE_SIZE value.

Syntax


>>-EXECUTE FUNCTION--+-admin-+--(--+-"statement cache nolimit <0/1>"-+----->
                     '-task--'
>--)--;-------------------------------------------------------------------><

Usage

This function is equivalent to the onmode -W STMT_CACHE_NOLIMIT {0|1} command.