Setting the Number of Sessions - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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. The default number of sessions is 1. (See “SESSIONS” on page 313 for more details.)

To specify more than one session in a set:

  • 4
  • At the BTEQ prompt:
  • Teradata BTEQ <version> for <OS>. Enter your logon or BTEQ command.

    enter:

    .SET SESSIONS n 

    where n is the number of sessions.