BEGIN QUERY LOGGING Syntax | Teradata Vantage - BEGIN QUERY LOGGING Syntax - Teradata Vantage - Analytics Database

BEGIN QUERY LOGGING
  [ WITH logging-option [,...logging-option] ]
  [ MODE = m ]
  [ DETAILDIAG = n [ STEPETTHRESHOLD = s ] ]
  [ LIMIT limit_option [ AND limit-option ] ]
  ON on_items [;]

logging-option

(ALL | EXPLAIN | [NO COLUMNS] OBJECTS | SQL | STEPINFO |
 PARAMINFO | [VERBOSE] XMLPLAN | [DETAILED] STATSUSAGE)

limit_option

{ SQLTEXT [ = n] |
 
  { SUMMARY = n1, n2, n3 | THRESHOLD [ = n ] }
    [ CPUTIME | CPUTIMENORM | ELAPSEDSEC | ELAPSEDTIME | IOCOUNT ]
}

on_items

      { ALL [ ACCOUNT = ('account id' [ ... ,'account id' ] ) ] }
   ON { user-name [ ACCOUNT = ('account id' [ ... ,'account id' ] ) ] }
      { user-name [ ... ,user-name ] }
      { database-name [ ... ,database-name ] }
      { APPLNAME = ('application-name' [ ... ,'application-name' ] ) } ;