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: