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.

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