Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET STATEMENT CACHE statementUse the SET STATEMENT CACHE statement to turn on caching or turn off caching for the current session. This statement is an extension to the ANSI/ISO standard for SQL.
SQL statement cache qualifying criteriaA statement that can be cached in the SQL statement cache (and consequently, one that can match a statement that already appears in the SQL statement cache) must meet specified conditions.
Enabling or Disabling Insertions After Size Exceeds Configured Limit

Enabling or Disabling Insertions After Size Exceeds Configured Limit

The DBA can prevent the insertion of additional qualified SQL statements into the statement cache when the cache size reaches its configured size (as specified by the STMT_CACHE_SIZE configuration parameter) by setting the configuration parameter STMT_CACHE_NOLIMIT to zero.