The Rewrite action replaces the SQL statement with an alternate statement. You can rewrite any type of SQL request, including data manipulation language commands, DIGITAL Command Language commands, and data definition language commands.
You can use symbols and reference bind variables to rewrite predicates in the incoming SQL statement.
If you want to use a symbol value to rewrite all or part of the SQL statement, use the expression
in the Alternate Statement field.
The following table describes the Rewrite action parameters:
Defines the SQL statement that the Rule Engine uses to rewrite the original SQL statement.
Rewriting Statements With Bind Variables
Use bind variable naming conventions to rewrite incoming statements.
The Rule Engine identifies the values in the positions specified by bind variables in the incoming statement. You must enter the same bind variable names in the predicate of the rewrite statement. The Rule Engine identifies the values in the incoming statement and rewrites the statement with the inserted values.