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