Session Controls | Basic Teradata Query - Session Controls - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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.