17.10 - SELECT HOST - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The SELECT HOST command selects the host number of a group of gateways, and the PEs that have been assigned to those gateways. Subsequent Gateway Global commands will affect only those selected gateways until a new SELECT HOST command is issued. In this context, the specified collection of gateways and PE comprises a host group.


{ SELECT | SE } { HOST | HO } host_no

Syntax Elements

Host group number.

Example: Specifying a host for subsequent Gateway Global commands

To select host group 1, type:

select host 1
IF the Host Group number is... THEN the following message appears...
found Host 1 has been selected.
not found Invalid Host 1 is entered. Please try again!

To deselect a host group, type:

select host 0