Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2451
lifecycle
previous
Product Category
Teradata Tools and Utilities

Usage Notes

If a LOGOFF command is entered while a transaction is in process (that is, a BEGIN TRANSACTION statement has been entered but an END TRANSACTION statement has not), the transaction is aborted and all affected tables are returned to the state before the BEGIN TRANSACTION statements. See SQL Data Manipulation Language (B035-1146) for additional information about the BEGIN/END TRANSACTION statements.

The following events occur at LOGOFF:

  • Outstanding locks for the user are released.
  • Any spool file containing the result of a SELECT statement is released.