ALTER SQL_TRANSLATOR RULE
Description
The ALTER SQL_TRANSLATOR RULE syntax is used to alter the SQL translator rule configuration.
Syntax
AlterSQLTranslatorRule ::=
'ALTER' 'SQL_TRANSLATOR' 'RULE' '(' sqlTranslatorRuleDefinition ')'
sqlTranslatorRuleDefinition ::=
algorithmDefinition (',' useOriginalSQLWhenTranslatingFailedClause)?
algorithmDefinition ::=
'TYPE' '(' 'NAME' '=' translatorType (',' 'PROPERTIES' '(' propertiesDefinition ')' )? ')'
useOriginalSQLWhenTranslatingFailedClause ::=
'USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED' '=' booleanLiteral
translatorType ::=
identifier
propertiesDefinition ::=
property (',' property)*
property ::=
key '=' value
booleanLiteral ::=
'TRUE' | 'FALSE'Note
TYPEdeclares the SQL translator implementation and itsPROPERTIES.USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILEDcontrols whether the original SQL should be used when translation fails.
Example
- Alter SQL translator rule with fallback on translation failure
ALTER SQL_TRANSLATOR RULE (
TYPE(NAME='NATIVE', PROPERTIES('key'='value')),
USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED=TRUE
);- Alter SQL translator rule without specifying fallback
ALTER SQL_TRANSLATOR RULE (
TYPE(NAME='NATIVE', PROPERTIES('key'='value'))
);Reserved word
ALTER, SQL_TRANSLATOR, RULE, TYPE, NAME, PROPERTIES, USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED, TRUE, FALSE