SELECT HOST - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

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.

Syntax

{ SELECT | SE } { HOST | HO } host_no
host_no
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