BTEQ - Commands for Session control in Teradata

ABORT
Abort any and all active running requests and transactions, but do not exit BTEQ.

DEFAULTS
Reset all BTEQ Format command options to their defaults. This will utilize the default configurations.

EXIT
Immediately end the current session or sessions and exit BTEQ.

HALT EXECUTION
Abort any and all active running requests and transactions and EXIT BTEQ.

LOGOFF
End the current session or sessions, but do not exit BTEQ.

LOGON
Starts a BTEQ Session. Every user, application, or utility must LOGON to Teradata to establish a session.

QUIT
End the current session or sessions and exit BTEQ.

SECURITY
Specifies the security level of messages between a network-attached system and the Teradata Database.

SESSIONS
Specifies the number of sessions to use with the next LOGON command.

SESSION CHARSET
Specifies the name of a character set for the current session or sessions.

SESSION SQLFLAG
Specifies a disposition of warnings issued in response to violations of ANSI syntax. The SQL will still run, but a warning message will be provided. The four settings are FULL, INTERMEDIATE, ENTRY, and NONE.

SESSION TRANSACTION
Specifies whether transaction boundaries are determined by Teradata SQL or ANSI SQL semantics.

SHOW CONTROLS
Displays all of the BTEQ control command options currently configured.

SHOW VERSIONS
Displays the BTEQ software release versions.

TDP
Used to specify the correct Teradata server for logons for a particular session.