REPLACE QUERY LOGGING Syntax | Teradata Vantage - REPLACE QUERY LOGGING Syntax - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
spp1591731285373.ditamap
dita:ditavalPath
spp1591731285373.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantageā„¢
REPLACE QUERY LOGGING [ WITH with_item [,...] ] [ MODE = m ] [ LIMIT limit_item [ AND limit_item ] ] ON on_items [;]

Syntax Elements

with_item
{ ALL | EXPLAIN | LOCK = n | NONE | [ NO COLUMNS ] OBJECTS | PARAMINFO | FEATUREINFO | SQL | [ DETAILED ] STATSUSAGE | STEPINFO | USECOUNT | UTILITYINFO | [ VERBOSE ] XMLPLAN }
limit_item
{ SQLTEXT [=n] | { SUMMARY = n1, n2, n3 | THRESHOLD [=n] } [ CPUTIME | CPUTIMENORM | ELAPSEDSEC | ELAPSEDTIME | IOCOUNT ] }
on_items
{ { ALL | user_name } [ ACCOUNT = { 'account_string' | ('account_string' [,...]) } ] | { user_name | database_name }[,...] | APPLNAME= { 'application_name' | ('application_name' [,...]) } }