BTEQ supports a maximum of 200 sessions. Specify the number of sessions in a set by entering the SESSIONS command prior to the LOGON command.
.SET SESSIONS n
where n is the number of sessions.
Example:
#bteq
Teradata BTEQ 15.10.01.01 for WIN32. PID: 2164
Copyright 1984-2016, Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.set sessions 5
.set sessions 5
Teradata BTEQ 15.10.01.01 for WIN32. Enter your logon or BTEQ command:
.logon DWTS/USER1
.logon DWTS/USER1
Password:
*** Logon successfully completed.
*** 5 Sessions logged on.
*** Teradata Database Release is 15.10.07.11
*** Teradata Database Version is 15.10.07.11
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.
*** Total elapsed time was 4 seconds.
BTEQ -- Enter your SQL request or BTEQ command: