Session Controls

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

The following commands control instigation and termination of database session use. In particular, the commands cover enabling use of multiple sessions and choosing an authentication mechanism.

BTEQ Command Function
LOGMECH and LOGDATA LOGMECH – This control enables users to specify the logon mechanism, such as NTLM, KRB5, LDAP or TD2, which defines the security context under which the established sessions will operate.

LOGDATA – This control enables users to specify a character string that is used to supply non-Teradata-managed user credentials to an external authentication mechanism.

LOGOFF Terminates a user's database sessions without exiting from BTEQ.
LOGON Connects a user to a Teradata Database.
LOGONPROMPT

This control enables users to specify whether prompts and warnings related to conventional LOGON command use is to be bypassed.

SESSIONS This control enables users to specify the number of database sessions that BTEQ is to request be logged on when the LOGON command is next used.
SESSION CHARSET This control enables users to specify the name of the character set for existing and future database sessions.
SESSION RESPBUFLEN This control enables users to specify the initial size of the client response buffer for future database sessions. It overrides the buffer length specified in the resp_buf_len entry in CLI’s System Parameter Block (SPB).
SESSION TWORESPBUFS This control enables users to specify whether CLI double-buffering is active or inactive. It overrides CLI’s System Parameter Block (SPB) two_resp_bufs entry for client response buffering.
TDP This control enables users to specify a new default tdpid for subsequent logons.