15.00 - REPLACE QUERY LOGGING - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

REPLACE QUERY LOGGING

Purpose of REPLACE QUERY LOGGING

REPLACE QUERY LOGGING is identical to BEGIN QUERY LOGGING except that it enables you to replace an existing query logging rule in DBC.DBQLRuleTbl by submitting a request to replace that rule with a new rule that has the options you specify for it. The following table is a high level summary of what a REPLACE QUERY LOGGING request does.

 

IF a rule …

THEN Teradata Database …

exists

replaces it.

does not exist

creates one that satisfies the REPLACE QUERY LOGGING specifications.

See “BEGIN QUERY LOGGING” on page 157 for more information relevant to this statement.