15.00 - Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

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.