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 | Enables specification of the security mechanism and other parameters (beyond userid and password) needed to authenticate using during logons. |
| LOGOFF | Terminates the user's Teradata Database sessions without exiting from BTEQ. |
| LOGON | Connects a user to a Teradata Database. |
| LOGONPROMPT | Enables bypass of prompts related to conventional LOGON command use. |
| SESSIONS | Specifies the number of Teradata Database sessions that BTEQ is to request be logged on when the LOGON command is next used . |
| SESSION CHARSET | Identifies the name of the character set for the current set of Teradata Database sessions. |
| SESSION RESPBUFLEN | Overrides the buffer length specified in the resp_buf_len entry in CLI's System Parameter Block (SPB). |
| SESSION TWORESPBUFS | Specifies whether CLI double-buffering is active or inactive. |
| TDP | Sets the tdpid as a default for subsequent logons during the current BTEQ session. |