Adds query rewrite patterns.
SyntaxREWRITE ADD id input regexp output regexp ;
- 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 Unity generates and sends to Teradata.
The following rewrite pattern forces all selected files on table myDb.myTable that does not have a where clause to use ACCESS locks.
unityadmin> REWRITE ADD forceAccessOnMyTable "^SELECT(.*)FROM myDb.myTable$" "LOCKING TABLE myDb.myTable FOR ACCESS SELECT \1 FROM myDb.myTable"; Rewrite rule add request completed successfully