15.10 - HostsInfoV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

LogicalHostId

SMALLINT

NOT NULL

ZZZ9 (explicit)

Hosts.LogicalHostId (UPI)

HostName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Hosts.HostName (USI)

DefaultCharSet

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Hosts.DefaultCharSet

If this view does not exist or no rows are found, user-defined international character sets are not available (see the “CharSetsV” on page 79), or have not been assigned as host defaults. In this case, the standard default is used (EBCDIC for IBM mainframe hosts and ASCII for all others).

Possible Values for DefaultCharSet

  • EBCDIC
  • ASCII
  • The name of a user-defined character set as displayed in the CharSets view.
  • The following SELECT statement selects any character sets assigned by the user as the defaults for the client systems in the Teradata Database configuration:

    ==> SELECT * FROM DBC.HostsInfoV;

    Result:

    LogicalHostId   ­HostName   ­DefaultCharSet
    -------------   ---------  ----------------
              136   VM         Norwegian_EBCDIC
              137   LAN        ASCII

    For more information about the user-defined character sets and the values in DBC.HostsInfo, see International Character Set Support.