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