15.00 - END QUERY CAPTURE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

END QUERY CAPTURE

Rules and Restrictions for END QUERY CAPTURE

  • An END QUERY CAPTURE request specified with WITH logging_option ends the scope of the BEGIN QUERY CAPTURE session issued with the specified option.
  • You can specify logging options for END QUERY CAPTURE requests throughout a BEGIN QUERY CAPTURE session to decrement the number of logging options being captured.

    Once an option has been removed from a query capture session, it can again be added later in the same session.

  • An END QUERY CAPTURE request specified with the ON ALL RULES option ends the scope of the active BEGIN QUERY CAPTURE session.
  • This means that all query capture options that had been enabled during the session are terminated and the session ends.

  • You cannot submit a valid END QUERY CAPTURE request if there is no active BEGIN QUERY CAPTURE session.
  • Otherwise, Teradata Database aborts the request and returns an error to the requestor.

  • You cannot submit an END QUERY CAPTURE request without also specifying either the WITH option or the ON ALL RULES option.
  • Otherwise, Teradata Database aborts the request and returns an error to the requestor.