BTEQ: Set number of Session in Teradata

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. 



where n is the number of sessions.




 Teradata BTEQ 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 for WIN32. Enter your logon or BTEQ command:

.logon DWTS/USER1


.logon DWTS/USER1



 *** Logon successfully completed.

 *** 5 Sessions logged on.

 *** Teradata Database Release is

 *** Teradata Database Version is

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.


 *** Total elapsed time was 4 seconds.


 BTEQ -- Enter your SQL request or BTEQ command: