User Guide

9.9
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Rewrite Action

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

\(Symbol_name)

in the Alternate Statement field.

The following table describes the Rewrite action parameters:

Parameter	Description
Alternate statement	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.

Rename Saved Search

Table of Contents

User Guide

User Guide

Rewrite Action

Rewrite Action

Rewriting Statements With Bind Variables