Session Control Commands - Basic Teradata Query

Function

Session Control Command

Start a Session

Start a BTEQ session.

LOGON

Specify the number of sessions to use with the next LOGON command.

SESSIONS

Specify the Teradata server for subsequent logons during the current session.

TDP

Bypass the warnings related to conventional LOGON command use.

LOGONPROMPT

End a Session

End the current sessions without exiting BTEQ.

LOGOFF

End the current sessions and exit BTEQ.

EXIT or QUIT

Abort any active requests and transactions without exiting BTEQ.

ABORT

Abort any active requests and transactions and exit BTEQ.

HALT EXECUTION

Display Session Information

Display the current configuration of the BTEQ control command options.

SHOW CONTROLS

Display the BTEQ version number, module revision numbers, and linking date.

SHOW VERSIONS

Specify Session Characteristics

Specify the name of a character set for the current session.

SESSION CHARSET

Specify the disposition of warnings issued in response to violations of ANSI-compliant syntax.

SESSION SQLFLAG

Specify whether transaction boundaries are determined by Teradata SQL semantics or ANSI semantics.

SESSION TRANSACTION

Specify whether CLI double-buffering is used.

SESSION TWORESPBUFS

Override the buffer length specified in resp_buf_len.

SESSION RESPBUFLEN

Override the precision specified by a CLI System Parameter Block (SPB) max_decimal_returned entry,

or if that entry does not exist,

indicate what the precision should be for decimal values associated with subsequently issued SQL requests for non-Field Mode responses.

DECIMALDIGITS