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:

Comments