Alter SQL_PARSER Rule
Description
The ALTER SQL_PARSER RULE syntax is used to alter the SQL parser rule configuration.
Syntax
AlterSqlParserRule ::=
'ALTER' 'SQL_PARSER' 'RULE' '(' sqlParserRuleDefinition ')'
sqlParserRuleDefinition ::=
parseTreeCacheDefinition? (',' sqlStatementCacheDefinition)?
parseTreeCacheDefinition ::=
'PARSE_TREE_CACHE' '(' cacheOption ')'
sqlStatementCacheDefinition ::=
'SQL_STATEMENT_CACHE' '(' cacheOption ')'
cacheOption ::=
('INITIAL_CAPACITY' '=' initialCapacity)? (','? 'MAXIMUM_SIZE' '=' maximumSize)?
initialCapacity ::=
int
maximumSize ::=
intNote
-
PARSE_TREE_CACHE: local cache configuration of the syntax tree. -
SQL_STATEMENT_CACHE: the local cache of SQL statement.
Example
- Alter SQL parser rule
ALTER SQL_PARSER RULE (
PARSE_TREE_CACHE(INITIAL_CAPACITY=128, MAXIMUM_SIZE=1024),
SQL_STATEMENT_CACHE(INITIAL_CAPACITY=2000, MAXIMUM_SIZE=65535)
);Reserved word
ALTER, SQL_PARSER, RULE, PARSE_TREE_CACHE, INITIAL_CAPACITY, MAXIMUM_SIZE, SQL_STATEMENT_CACHE