REWRITE ADD Command | bcmadmin | Teradata Business Continuity Manager - REWRITE ADD - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Adds query rewrite patterns.

Syntax

REWRITE ADD id input regexp output regexp ;

Parameters

id
A unique string to identify the specific Rewrite Rule.
input regexp
The Tool Command Language (TCL) regular expression that enables matching SQL from a client.
To make sure that only the SQL required is matched, make the input regexp pattern be as specific as possible. Include a ^ at the beginning and a $ at the end of each pattern.
output regexp
The SQL regular expression that Business Continuity Manager generates and sends to Teradata.

Example

The following rewrite pattern forces all selected files on table myDb.myTable that does not have a where clause to use ACCESS locks.

bcmadmin>  REWRITE ADD forceAccessOnMyTable "^SELECT(.*)FROM myDb.myTable$" "LOCKING TABLE myDb.myTable FOR ACCESS SELECT \1 FROM myDb.myTable"; 
Rewrite rule add request completed successfully